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 Bonkoski||Date: 2000-04-06 14:42:04|
|Subject: Still Looking|
|Previous:||From: Tressens Lionel||Date: 2000-04-06 10:02:49|
|Subject: changing the owner of a db|