Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Using Epoch...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 7 Topic 15492 of 16953
Post > Topic >>

Re: Using Epoch to save timestamps in 4 bytes?

by tgl@[EMAIL PROTECTED] (Tom Lane) May 10, 2008 at 09:37 PM

Francisco Reyes <lists@[EMAIL PROTECTED]
> writes:
> Given that all of our dates will fall within what we can store in
4bytes, 
> what would be the easiest way to use epoch as a timestamp?

Well, if you're bound and determined to create a Y2038 problem for
yourself, you could use the legacy "abstime" datatype.

Actually, that choice will blow up on you rather sooner than 2038,
since I'm sure we'll pull abstime from the system well before it
actually starts failing to represent now().  But future-proofing
doesn't seem to be part of your design goals, so you might as well
use it while it's there.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 7 Posts in Topic:
Using Epoch to save timestamps in 4 bytes?
lists@[EMAIL PROTECTED]   2008-05-08 23:57:47 
Re: Using Epoch to save timestamps in 4 bytes?
bruce@[EMAIL PROTECTED]   2008-05-09 00:00:51 
Re: Using Epoch to save timestamps in 4 bytes?
lists@[EMAIL PROTECTED]   2008-05-10 20:47:11 
Re: Using Epoch to save timestamps in 4 bytes?
tgl@[EMAIL PROTECTED] (T  2008-05-10 21:37:29 
Re: Using Epoch to save timestamps in 4 bytes?
scott.marlowe@[EMAIL PROT  2008-05-09 01:15:57 
Re: Using Epoch to save timestamps in 4 bytes?
mmoncure@[EMAIL PROTECTED  2008-05-09 08:51:26 
Re: Using Epoch to save timestamps in 4 bytes?
tgl@[EMAIL PROTECTED] (T  2008-05-09 10:02:59 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 10:02:44 CDT 2008.