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

[Cris Carampa]

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match