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: Pine.LNX.3.96.1000406122438.13674A-100000@ara.zf.jcu.cz (view raw or flat)
Thread:
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. 

						Karel


In response to

Responses

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-2014 The PostgreSQL Global Development Group