On 9/4/06, Alban Hertroys <alban@magproductions.nl> wrote:
> Michael Glaesemann wrote:
> > Note that epoch does not mean 1900-01-01 00:00:00.
>
select *, timestamp 'EPOCH' + "timestamp" * interval '1 second' as
tstamp from ccmanager_log where id > 15400
select *, timestamp '1900-01-01 00:00:00' + "timestamp" * (interval
'1 second') from ccmanager_log where id > 15400
I tried both of these and the worked - but them timestamp '1900-01-01
00:00:00' gives dates that are 70 years of so it should be
'1970-01-01 00:00:00'
The sheer guruhood of PostgreSQL users is amazing.
Which topics in the manual discusses these issues in depth?
> Indeed! Where did this 1900 sneak in? Aren't timestamps usually based on
> epoch?
>
> --
> Alban Hertroys
> alban@magproductions.nl
>
> magproductions b.v.
>
> T: ++31(0)534346874
> F: ++31(0)534346876
> M:
> I: www.magproductions.nl
> A: Postbus 416
> 7500 AK Enschede
>
> // Integrate Your World //
>