-
24 hour date/ time?
How does one select a 24 hour / type of time from DUAL?
I’m working on an app where the users are required to work / enter times in a 24 hour format.
Code:
-- this works
SELECT to_date('16-JUL-2003 12:30:00','DD-MON-YYYY HH:MI:SS') FROM DUAL
-- this one creates an error Hour must be between 1 and 12
SELECT to_date('16-JUL-2003 13:30:00','DD-MON-YYYY HH:MI:SS') FROM DUAL
-
Hi,
I think this should solve ur problem
SELECT to_date('16-JUL-2003 13:30:00','DD-MON-YYYY HH24:MI:SS') FROM DUAL
HTH
Srini
-