Strange query results with dates

Поиск
Список
Период
Сортировка
От Igor Khanjine
Тема Strange query results with dates
Дата
Msg-id 2517954767.20001023164125@mailru.com
обсуждение исходный текст
Ответ на Re: please help me with arrays  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Strange query results with dates  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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.



В списке pgsql-general по дате отправления:

Предыдущее
От: Joerg Hessdoerfer
Дата:
Сообщение: Re: Weird effects using BLOBs from libpq
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange query results with dates