Re: [GENERAL] Default date format to ISO + 1 bug - Mailing list pgsql-general

On Thu, Jan 13, 2000 at 10:09:35AM -0500, Web Manager wrote:
> Hello,
>
> since I am a simple Postgres user, I don't understand the instruction to
> change the postgresql default date format from 01-13-2000 to 2000-01-13

Either set the environment variable 'PGDATESTYLE', eg for csh

setenv PGDATESTYLE European

or in your connection to the database

SET DateStyle TO 'European';

> And then... I have a second broblem:
... 'now' broken, now() working
> What is wrong?

I think this one was mentioned a few days ago, so it's a "known problem"?

Cheers,

Patrick