Re: [GENERAL] Default date format to ISO + 1 bug

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: Web Manager <web(at)inter-resa(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Default date format to ISO + 1 bug
Date: 2000-01-13 15:58:05
Message-ID: 20000113155805.J12705@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Culberson, Philip 2000-01-13 17:11:39 RE: [GENERAL] Simulating an outer join
Previous Message Jim Mercer 2000-01-13 15:39:52 Re: [GENERAL] Default date format to ISO + 1 bug