Search Postgresql Archives

Re: Dates

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxx>
> To: "Bob Pawley" <rjpawley@xxxxxxx>
> Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxx so that your
>        message can get through to the mailing list cleanly


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux