At 20:00 +0200 on 17/12/98, Tim Williams wrote:
> I see the following results:
>
> m1|m2
> --+--
> 5| 6
> (1 row)
>
> Why is date_part giving different results for date and date_time? Why
> is it wrong for 'date'? Anybody seen this before?
Basically, it's a timezone problem.
When you give bare dates, they give you midnight of that same day. My guess
is that since date does not contain the timezone information contained in
datetime, it somehow forgets daylight saving time in its interpretation
into the internal format or out of it.
What's your timezone? Have you tried changing it to see whether it affects
the result?
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma