Re: how can i get the binary format of timestamp?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "energumen(at)buaa(dot)edu(dot)cn" <energumen(at)buaa(dot)edu(dot)cn>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: how can i get the binary format of timestamp?
Date: 2006-04-18 13:47:42
Message-ID: 12638.1145368062@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"energumen(at)buaa(dot)edu(dot)cn" <energumen(at)buaa(dot)edu(dot)cn> writes:
> timestamp is defined as int64 or float8, when it is defined as int64, it looks like timeval, first 32 bits for seconds,second 32 bits for usec.

No, it's seconds times 1000000, not times 2^32.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-04-18 14:14:37 Re: Question on win32 semaphore simulation
Previous Message Bruce Momjian 2006-04-18 12:44:32 Re: Is full_page_writes=off safe in conjunction with