Dates in inserts - Mailing list pgsql-general

From Michal Kalanski
Subject Dates in inserts
Date
Msg-id 080a01c2f84e$242dbcf0$1400a8c0@mikala
Whole thread Raw
Responses Re: Dates in inserts  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Dates in inserts  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
List pgsql-general
Hello

I have a table:

CREATE TABLE public.dates (
date timestamp
)

From psql I run following inserts:

insert into dates values('13.01.03');
insert into dates values('01.13.03');

and I run select:

select * from dates order by date;

result:

        date
---------------------
 2003-01-13 00:00:00
 2003-01-13 00:00:00
(2 rows)

Why postgresql inserts the same dates ?


Thanks a lot,
Michal


pgsql-general by date:

Previous
From: Markus Wagner
Date:
Subject: Re: row-level locking
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Dates in inserts