Printable View
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?
Dear Martin,
Dear Martin,
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.
Regards,
Eldo.