Re: Oracle date format
From: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Wed, 10 Nov 2004 20:47:38 GMT
Message-ID: <K7vkd.136619$df2.94046_at_edtnps89>
>> 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
Date: Wed, 10 Nov 2004 20:47:38 GMT
Message-ID: <K7vkd.136619$df2.94046_at_edtnps89>
Dom wrote:
> 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; > > - Dom
Which question is that answering? That is simply converting sysdate to _your_ specified format, which has absolutely nothing to do with the default format, which is part of what the OP was looking for. Received on Wed Nov 10 2004 - 21:47:38 CET