How to enter a date and time without to_date()

[Mlwhite]

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?

[eldoskaria]

Dear Martin,

[eldoskaria]

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.