ORA-01849 hour must be between 1 - 12

lorien · **Joined:** Thu Jan 22, 2004 8:35 pm **Posts:** 1

Has anyone here had any dealings with queries that use a timestamp in a where clause hitting an Oracle 9i database? The problem I am having is that I can

emmanuel · **Posted:** Fri Jan 23, 2004 5:25 pm

Some AM PM to add somewhere

:LJ: · **Joined:** Tue Feb 03, 2004 11:52 am **Posts:** 1

This is a setting on the Oracle server instance :

http://www.orafaq.com/parms/parm480.htm

Either change your time format to hh12:mm:ss or alter the server instance parameter to allow the dates you're feeding into it.