============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Maxime Zakharov
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium II
Operating System (example: Linux 2.0.26 ELF) : FreeBSD 3.4-RELEASE
PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.5.3
Compiler used (example: gcc 2.8.0) : egcs-2.91.60
Please enter a FULL description of your problem:
------------------------------------------------
apth=> select ('now'::date - '1 day'::interval)::datetime;
datetime
----------------------------
Fri Mar 24 23:00:00 2000 MSK
(1 row)
But today (or 'now') is Sun Mar 26 XX:YY:ZZ 2000 MSD and result should
be
Sat Mar 25 00:00:00 2000 MSK
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Today daylight savings time has applied.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
--
Maxime Zakharov
Sochi, Russia
http://sochi.net.ru/~maxime/
