Thread: setting a non-standard date format for the duration of a session

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.

Thank you. Kind regards, Cris

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