Re: - pgaql binary data date time fornats

From: Neeraj Rai <rneeraj(at)yahoo(dot)com>
To: "pgsql-interfaces(at)postgresql(dot)org" <pgsql-interfaces(at)postgresql(dot)org>, Neeraj Rai <rneeraj(at)yahoo(dot)com>
Subject: Re: - pgaql binary data date time fornats
Date: 2013-05-22 16:52:10
Message-ID: 1369241530.69063.YahooMailAndroidMobile@web164901.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

Hi,

I forgot to mention that I'm trying to use binary data format.
I found exanples of sending string fornatted date time. However, i am assuming there are functions to covert unix time to pgtimestamptz and may be faster
Looking for inverse of ts.epoch

I can bypass bitwise fueld issue by assigning to int.
I think Q5 can be ignored. It should work the same for execparams and execprepared.

Thanks
Neeraj

In response to

  • at 2013-05-22 01:26:08 from Neeraj Rai

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2013-05-22 16:58:13 Re: VACUUM FULL freezes
Previous Message Cody Cutrer 2013-05-22 16:41:12 Ambiguous order by?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Neeraj Rai 2013-05-22 23:52:13 - pgaql long value corrupted using htons
Previous Message Neeraj Rai 2013-05-22 01:26:08