How to enter a date and time without to_date()
I am using a web package that creates insert statements for me. If it reads a row that contains date and time info it creates an insert statement using a preset format model. I can tune this format model to match the format oracle is expecting but I can't work out what format to include the time element. Any ideas?
Martin L White
OCP DBA 8i
Argue your limitations and they are yours....
Please discard my earlier message.
In the subject matter, from the web, anyway you would be calling a SQL session. At that time, you can set the default date format you want by NLS_DATE_FORMAT which can take care of time component also. Hereafter you may set any time format suitable for you.
Hope I'm clear.
Click Here to Expand Forum to Full Width