Try this (6.5):
test=> show DATESTYLE;
NOTICE: DateStyle is Postgres with European conventions
SHOW VARIABLE
test=> select * from JUNK_QWERTY;
id| mydate
--+----------
1|01-02-1999
2|24-03-1999
3|24-11-1999
You can select which DATESTYLE to use
SET DATESTYLE TO 'ISO'|'SQL'|'Postgres'|'European'|'US'|'NonEuropean'
I run postgres with -e option, i.e. European format DD-MM-YYYY on default.
Regards,
Oleg
On Tue, 29 Jun 1999, Colin Price (EML) wrote:
> Date: Tue, 29 Jun 1999 21:53:24 +0200
> From: "Colin Price (EML)" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: [ADMIN] 6.4.2 and 6.5 date usertype difference
>
>
> I have just replicated a db in 6.5 from 6.4.2.
>
> The table selects the date differently from the identical table.
> I obviously set a parameter in 6.4.2 which I now cannot find (from
> mail list archive and doc as well).
>
> Please aid someone who is tearing his hair out.
> Thank you in advance,
> Colin.
>
> The table & contents :
> CREATE TABLE JUNK_QWERTY (
> id int,
> mydate date
> );
> insert into JUNK_QWERTY values (1, '1999-02-01');
> insert into JUNK_QWERTY values (2, '1999-03-24');
> insert into JUNK_QWERTY values (3, '1999-11-24');
>
> 6.4.2 output :
> timesheet=> select * from JUNK_QWERTY;
> id| mydate
> --+----------
> 1|1999-02-01
> 2|1999-03-24
> 3|1999-11-24
> (3 rows)
>
> 6.5 output :
> timesheet=> select * from JUNK_QWERTY;
> id| mydate
> --+----------
> 1|02-01-1999
> 2|03-24-1999
> 3|11-24-1999
> (3 rows)
>
> ==============================================================
> ==============================================================
> 6.4.2 version :
> timesheet=> select version();
> version
>
> -------------------------------------------------------------
> PostgreSQL 6.4.2 on i586-pc-linux-gnu, compiled by gcc
> 2.7.2.
>
> 6.5 version :
> timesheet=> select version();
> version
>
> --------------------------------------------------------------
> PostgreSQL 6.5.0 on i686-pc-linux-gnu, compiled by gcc
> 2.7.2.3
> (1 row)
>
>
>
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
