Re: [SQL] setting a non-standard date format for the duration of a session

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 s

[SQL] 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.