Re: Date-Time Command in ORACLE

[Parijat Sahai <parijatsahai@HOTMAIL.COM>]

Why don't you use the function Format-Datetime to convert your date to
native datetime format? This function takes care of the database you're
working on.

Parijat

>
>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
>


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com