Re[2]: Strange query results with dates - Mailing list 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).