Re[2]: Strange query results with dates

From: igor <igor_kh(at)mailru(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re[2]: Strange query results with dates
Date: 2000-10-24 10:46:30
Message-ID: 42690332.20001024144630@mailru.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running 7.02 on RedHat 6.0
and these queryes work with error result,
but I found the solution -
select abstime '2000-05-02'
and
select date_trunc('month',abstime '2000-05-02')
both work properly.

May be I have to install the next release of PG?
Tell me please what is the last available?
(I think 7.02 - is it right?)

Thanks for help!

Regards.

Igor

play=>> SET DATESTYLE ='GERMAN';
TL> SET VARIABLE
play=>> select abstime '02.05.00';
TL> ?column?
TL> ----------------------------
TL> 02.05.2000 00:00:00.00 EDT
TL> (1 row)

play=>> select date_trunc('month',abstime '02.05.00');
TL> date_trunc
TL> ----------------------------
TL> 01.05.2000 00:00:00.00 EDT
TL> (1 row)

TL> Either it's been fixed since 7.0 release, or there is something peculiar
TL> about the datetime support on your platform (which you didn't specify).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gilles DAROLD 2000-10-24 10:51:24 PL/Perl compilation error
Previous Message Douglas 2000-10-24 08:11:01 Re: pgsql 7.0.2 on RH6.2 regression test failed