Re: Date formats in 7.0b2

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