Re: Date-Time Command in ORACLE

[Vince Mancino <e5d4@EARTHLINK.NET>]

You must inclose the datetime with a prefix and suffix. Here is the code
for the insert:
{DateTimeIn-Prefix}$SysDateTime{DateTimeIn-Suffix}
Replace the $SysDateTime with your datetime.
In the select code the same line but with "DateTimeOut-".

Hood, Paul wrote:

> 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