big int

From: newsreader(at)mediaone(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: big int
Date: 2001-03-11 13:52:44
Message-ID: 20010311085243.A7770@dragon.universe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: big int at 2001-03-11 21:48:30 from Richard Huxton

Browse pgsql-general by date

  From Date Subject
Next Message Brian C. Doyle 2001-03-11 14:08:24 Re: Win32 Postgresql
Previous Message Lincoln Yeoh 2001-03-11 13:51:24 Re: Anyone can create tables!