Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle date format
"Bill" <bill_at_tadi.com> wrote in message news:cme261$24$1_at_news.sap-ag.de...
| 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
|
Bricklen was right -- I missed you comment about not be able to use those functions.
I suppose the question is why? That's the only way you can convert string data to Oracle's internal date/time format.
Also, you may be aware of those functions, but it does appear you do need to read up a bit more and see why they are necessary and how Oracle handles dates -- also investigate the NLS_DATE_FORMAT and related parameters.
Could you shed some light on why you cannot use those functions? I'm afraid if you can't, you will not be able to date and time values in your application. Seriously.
++ mcs Received on Thu Nov 04 2004 - 14:43:24 CST
![]() |
![]() |