[GENERAL] Strange query results with dates

[Igor Khanjine]

Hi!

Help me please to resolve my problem.
I cann't understand why my query returns very strange results.

select  datop  from mytable where date_trunc('month',datop)
  =date_trunc('month',abstime '22.05.00')
  
 it returns a strings with operations which were made in May,
 
but similar query 

select  datop  from mytable where date_trunc('month',datop)
  =date_trunc('month',abstime '02.05.00')
  
 it returns operations which were made in february !
 
I'm running PGSQL 7.0 , 
SET DATESTYLE ='GERMAN'
SET TIME ZONE 'EUROPE/MOSCOW'

Tell me please , what I made wrong?


Thanks for any suggestions.

Igor.