I have date from 01/01/1859 to up till date of today.
I have some sessions in these dates of some subjects.
Now I have to create a time table.
In one day there are five sessions like Monday have five slots, slot 1 slot 2 slot 3 slot 4 slot 5.
I have to make a query that if sessions lie on the Wednesday, session should lie in the Wednesday column. And particular slot of that Wednesday which i give to session.