From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Dates |
Date: | 2006-01-18 18:22:17 |
Message-ID: | 1137608537.25500.81.camel@state.g2switchworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Oh yeah, right. You want to set your datestyle.
See:
Changing it once:
http://www.postgresql.org/docs/8.1/static/datetime-appendix.html
Changing it for a database:
http://www.postgresql.org/docs/8.1/static/sql-alterdatabase.html
Changing it for everything that doesn't override it:
http://www.postgresql.org/docs/8.0/static/runtime-config.html
On Wed, 2006-01-18 at 12:17, Bob Pawley wrote:
> Perhaps you have a solution??
>
> Bob
>
> ----- Original Message -----
> From: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>
> To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
> Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
> Sent: Wednesday, January 18, 2006 10:03 AM
> Subject: Re: [GENERAL] Dates
>
>
> > On Wed, 2006-01-18 at 12:00, Bob Pawley wrote:
> >> Hi Folks
> >>
> >> I have a column for date which defaults to the ambigous 2005-1-1
> >> format.
> >>
> >> The documantation indicates how to change this to the unambigous Jan 1
> >> 2005, but the instructions aren't clear to me.
> >
> > Actually, if the year comes first, it is not ambiguous. It will always
> > be month-day if the year comes first. It's the
> >
> > mm/dd/yyyy or dd/mm/yyyy that is the issue.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin | 2006-01-18 18:23:03 | Re: Huge number of disk writes after migration to 8.1 |
Previous Message | Bob Pawley | 2006-01-18 18:17:37 | Re: Dates |