Re: Date-Time Command in ORACLE

[Tamilselvan Thambirajan <pstmp1@LEXMARK.COM>]

Hi Paul,

Use the following command:

date-time () DD-MON-YYYY HH:MI:SS &dttm_stamp

Edit mask surrended by Single ' was an error.

Tamilselvan




"Hood, Paul" <HoodP%bv.com@interlock.lexmark.com> on 08/05/98 03:24:26 PM

Please respond to SQR-USERS%usa.net@interlock.lexmark.com

To:   Multiple recipients of list SQR-USERS
      <SQR-USERS%list.iex.net@interlock.lexmark.com>
cc:    (bcc: PSTMP1/Lex/Lexmark)
bcc:  PSTMP1/Lex/Lexmark
Subject:  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