Skip site navigation (1) Skip section navigation (2)

Re: Date/Time atributes and binary cursors

From: "Gonalo Marrafa" <gjm(at)uevora(dot)pt>
To: L J Bayuk <ljb220(at)mindspring(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Date/Time atributes and binary cursors
Date: 2004-04-06 09:04:03
Message-ID: 20040406100403.3a60c461.gjm@uevora.pt (view raw or flat)
Thread:
Lists: pgsql-interfaces
Thanks.

Do Postgres/libpq have functions for converting between Unix/Postgres date/time representations or do i have to do it by hand?

Thanks again.

 
> A date is returned as a 4-byte big-endian integer representing the number
> of days since POSTGRES_EPOCH_DATE.
> A timestamp is returned as an 8-byte big-endian double precision number of
> seconds since POSTGRES_EPOCH_DATE.
> A time is returned as an 8-byte big-endian double precision number of
> seconds since midnight.
> POSTGRES_EPOCH_DATE is January 1, 2000 (2000-01-01).
> 
> Note that binary cursor results are in network data order (big-endian)
> starting with PostgreSQL-7.4 (versus native server order pre-7.4). This
> means they need to be byte-swapped if your client runs on an Intel-type
> little-endian system.
> 


-- 
Gonçalo Marrafa <gjm(at)uevora(dot)pt>

In response to

Responses

pgsql-interfaces by date

Next:From: Ryan MooneyDate: 2004-04-06 18:07:15
Subject: Re: Date/Time atributes and binary cursors
Previous:From: L J BayukDate: 2004-04-06 01:14:54
Subject: Re: Date/Time atributes and binary cursors

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group