Bill wrote:
> Hi,
> Thank you for everybody's comments.
>
> I am aware of the various Oracle functions available, e.g. TO_DATE.
> However, if I am NOT able to use those functions, how can I insert a time
> value into a column.
>
> I can do a "select sysdate from dual;" to find the date format I need to
> enter. How do I get the time format? or data and time format, combined in
> 1 string.
>
> Thanks
>
>
>
>
> "Bill Li" <bill_at_tadi.com> wrote in message
> news:cmdr02$pdk$1_at_news.sap-ag.de...
>
>>Hi all,
>>I am trying to insert date/time value into a column with datatype date.
>>During this insertion, I cannot use to_date or any other Oracle functions.
>>
>>When I use the string, '01-jan-2004', the value is inserted okay.
>
> However,
>
>>when I included the time, e.g. '01-jan-2004 01:01:01', I get the error
>>ORA-01830 (date format picture ends before converting entire input
>
> string).
>
>>Does anyone know what is the native string value I can use to when insert
>>into a date datatype?
>>
>>Thanks,
>>Bill
select to_char(sysdate,'mm/dd/yy hh:mi:ss') from dual;
Received on Wed Nov 10 2004 - 14:38:59 CST
