big int - Mailing list pgsql-general

From newsreader@mediaone.net
Subject big int
Date
Msg-id 20010311085243.A7770@dragon.universe
Whole thread Raw
List pgsql-general
This isn't exactly related to pg but
I thought some wise person might be able
to explain.

i've been storing the number of seconds
since  Dec 31 19:00:00 1969 whenever
I have to store a time format. For this
integer type is good.

As we all know come year 2032 or so this
number will exceed the range of integer.

If I want to prevent problems in the future
should I use int8.  Is there significant
overhead?  It seems that on an DEC/alpha
64 bit platform perl does not seems
to be aware that it's not on a 32 bit platform.
--------------
% perl -MTime::Local -e 'print timelocal(9,9,9,9,9,200)' ;
Can't handle date (9, 9, 9, 9, 9, 200) at -e line 1
--------------

Thanks


pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: Anyone can create tables!
Next
From: "Brian C. Doyle"
Date:
Subject: Re: Win32 Postgresql