[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



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