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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Cris Carampa <cris119(at)operamail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: setting a non-standard date format for the duration of a session
Date: 2004-04-10 15:19:19
Message-ID: 200404100819.19580.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2004-04-10 15:51:14 Re: SQL challenge--top 10 for each key value?
Previous Message Josh Berkus 2004-04-10 15:16:40 Re: hi sir urgent..required a Query