Order by time stored as Varchar

Question

I have a column(s_time) as varchar. I store 12 hours time(7:00 AM). I want to order by this column(s_time). I tried with this oracle query

select * from tabl_time order by to_date('s_time','hh12:mi') asc

But this did not work. Can anyone help me doing this?

Thanks in advance.

I want to sort by the s_time column. s-time has time(like 07:00 AM) — Shanna, Feb 17 '14 at 13:34

Raphaël Althaus · Accepted Answer · 2014-02-17T13:40:39.893

1

you seem to be missing the AM / PM part in your format, which can be represented by AM or PM (or in doc also by A.M. or P.M. but I have some problems with the dot version in fiddle at least)

select * from table_time 
order by to_date(s_time, 'HH12:MI AM') asc

edited Feb 17 '14 at 13:40

answered Feb 17 '14 at 13:34

Raphaël Althaus

59,727
6
96
122

score 1 · Answer 2 · answered Feb 17 '14 at 13:36

1

to_date('s_time','HH12:MI AM') ASC

answered Feb 17 '14 at 13:36

sqlab

6,412
1
14
29

Order by time stored as Varchar

2 Answers2