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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org