Cris,
> I understand I can use the function to_date(s,f) for converting a string
> into a date using a non-standard format.
>
> I'm wondering if there is a way to set a non-standard date format for
> the duration of a session, something like the "ALTER SESSION SET
> NLS_DATE_FORMAT='f'" Oracle statement.
Sort of. See the Docs on "Runtime Configuration" on the GUC variable
"Datestyle".
--
Josh Berkus
Aglio Database Solutions
San Francisco