[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Date-Time Command in ORACLE
- Subject: Date-Time Command in ORACLE
- From: "Hood, Paul" <HoodP@BV.COM>
- Date: Wed, 5 Aug 1998 14:24:26 -0500
I am attempting to use the DATE-TIME command to populate a DTTM_STAMP
field. I need the date as well as time in my inserted value. The line
below is what I am attempting to use.
When I try to insert it I get the error
ORA-01830: date format picture ends before converting entire input
string.
What is the correct mask to insert my value using ORACLE?
date-time () 'DD-MON-YYYY HH:MI:SS' &dttm_stamp
Thanks,
Paul