Skip site navigation (1) Skip section navigation (2)

Re: Date formats in 7.0b2

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: "Hernan J(dot) Gonzalez" <leonbloy(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: Date formats in 7.0b2
Date: 2000-04-06 10:27:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
On Wed, 5 Apr 2000, Hernan J. Gonzalez wrote:

> I'm puzzled with the date formats in
> the 7.0b2 version. Perhaps I'm missing something
> trivial, (SQL standards?) but I have been using postgres
> from years, and never had this kind of problem.
> I use the -e switch, so that
> > dates passed to and from the
> > frontend processes will be
> > assumed to be in "European" format (DD-MM-YYYY)
> (from the postgres man page)
> Now, it seems that 7.0b2  accepts dates in this
> format  AS INPUT but the dates  in the OUTPUT
> are always in the YYYY-MM-DD  format ...

 You can use in 7.0 to_char() to_date() to_timestamp() functions for full 
date-time format controlling or conversion. 


In response to


pgsql-admin by date

Next:From: Brad BonkoskiDate: 2000-04-06 14:42:04
Subject: Still Looking
Previous:From: Tressens LionelDate: 2000-04-06 10:02:49
Subject: changing the owner of a db

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group