DinoVaught
07-17-2003, 10:32 AM
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.
-- 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
I’m working on an app where the users are required to work / enter times in a 24 hour format.
-- 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