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

From: Cris Carampa <cris119(at)operamail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: setting a non-standard date format for the duration of a session
Date: 2004-04-07 12:47:52
Message-ID: c50t9n$s8v$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ricardo Vaz Mannrich 2004-04-07 13:44:20 Re: SQL Standatd
Previous Message Stefan Weiss 2004-04-07 10:06:20 Counting rows from two tables in one query