pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsetting a non-standard date format for the duration of a session
2+ messages / 2 participants
[nested] [flat]
* setting a non-standard date format for the duration of a session
@ 2004-04-07 12:47 Cris Carampa <cris119@operamail.com>
2004-04-10 15:19 ` Re: setting a non-standard date format for the duration of a session Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 2+ messages in thread
From: Cris Carampa @ 2004-04-07 12:47 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: setting a non-standard date format for the duration of a session
2004-04-07 12:47 setting a non-standard date format for the duration of a session Cris Carampa <cris119@operamail.com>
@ 2004-04-10 15:19 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 2+ messages in thread
From: Josh Berkus @ 2004-04-10 15:19 UTC (permalink / raw)
To: Cris Carampa <cris119@operamail.com>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-10 15:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-07 12:47 setting a non-standard date format for the duration of a session Cris Carampa <cris119@operamail.com>
2004-04-10 15:19 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox