baskaran chellasamy

baskaran chellasamy

  • NA
  • 114
  • 150.1k

how to get sql table data from following format

Apr 23 2013 10:57 AM
Hi friends 

       the following is the actual format in table period_details
PeriodNo StartTime EndTime
1 09:00 10:00
2 10:01 11:00
3 11:10 12:10
4 12:11 01:10
5 02:01 03:00
6 03:01 04:00
L 01:11 02:00

but i want to select as 

follows
PeriodNo StartTime EndTime
1 09:00 10:00
2 10:01 11:00
3 11:10 12:10
4 12:11 01:10
L 01:11 02:00
5 02:01 03:00
6 03:01 04:00


How to write a query for this view


Answers (1)