"Rob van Gelder" wrote ...

Is that really 'Oracle's date format' or are you merely making the
month unambiguous? Is it possible for the DBA to change 'Oracle's date
format' or is it always the same?

I believe there is a session level variable called nls_date_format, which
defaults to dd-mmm-yyyy

It was meant as a heads up to the OP, along the lines of:

http://groups.google.com/groups?selm...g .google.com

This is your captain speaking. The irony filter has now been
extinguished.

--