1
Answer

How Can I Compare Time From A Date Time Table.

Dhilu Das

Dhilu Das
9y
757
1
I have a table like this.

ID         Number         Date and Time
1        1026                5/9/2015, 08:15
2        1024                5/9/2015, 09:00
3        1030                5/9/2015, 11.00
4        1024                5/9/2015, 16.00
5        1026                5/9/2015, 16.40
6        1055                5/9/2015, 17.22
7        1040                5/10/2015, 11.00
8        1041                5/10/2015, 12.00
9        1040                5/10/2015, 16.40
10      1041                5/10/2015, 17.22

I want to sort the time in such a way that the time before 10 AM and after 05 pm in a particular date


 
Answers (1)
Next Recommended Forum