SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01850 hour must be between 0 and 23

senthilmcaSep 17 2007 — edited Sep 17 2007

Hi
Is it possible to insert the below record in a table

insert into datetest values(to_date('10/10/2007 24:00','dd/mm/yyyy hh24:mi'));
The datatype for a column in DATE..

While executing the above query i got the below error
ORA-01850..

Is it possible while issuing the above query will insert as 1 AM in the DB(Using query itself)

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2007

Added on Sep 17 2007

13 comments

9,741 views