Re: [BUGS] extract epoch bug

2005-07-05 Thread Tom Lane
[EMAIL PROTECTED] (Hans Olav Eggestad) writes: > I've just installed v8.0.3 and tested the 'epoch' part of extract, which for > my applications is fundamental. here is the result: > [ snip ] Nothing wrong with that that I can see. If you want a date to be interpreted as midnight GMT rather than m

Re: [BUGS] extract epoch bug

2005-07-05 Thread Achilleus Mantzios
O Hans Olav Eggestad έγραψε στις Jul 5, 2005 : > I've just installed v8.0.3 and tested the 'epoch' part of extract, which for > my applications is fundamental. here is the result: > > jova=# select extract(epoch from timestamp '19700102')\g > date_part > --- > 82800 > (1 row) > >