| Lists: | pgsql-interfaces |
|---|
| From: | Shoaib Naazir <je_shoaib(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Query regarding PostgreSQL date/time binary format for libpq |
| Date: | 2007-01-25 13:08:47 |
| Message-ID: | BAY124-W14A44C6A2BDB40EC97B2F381A30@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
Hi, I am working on an application using PostgreSQL. I need to send date to PostgreSQL in binary format using the libpq interface. I have walked through the PostgreSQL code base, did find some reference to the date/time binary format but didn't get the exact format. To much code to digest in one parse :). Can you please provide me with any good reference to the exact binary format dbserver expect for date/time. I just can't use the text format :(. Any reference material, paper, web page or a mail specifying the exact binary date/time format will do. Thanks in advance. I really appreciate your time. regards,Shoaib Naazir.
Artificial intelligence is no match for natural stupidity.
_________________________________________________________________
Get into the holiday spirit, chat with Santa on Messenger.
http://imagine-windowslive.com/minisites/santabot/default.aspx?locale=en-us
| From: | imad <immaad(at)gmail(dot)com> |
|---|---|
| To: | "Shoaib Naazir" <je_shoaib(at)hotmail(dot)com> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Query regarding PostgreSQL date/time binary format for libpq |
| Date: | 2007-01-26 20:21:21 |
| Message-ID: | 1f30b80c0701261221t9bd0735yb221c7dfbc9fc6ad@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-interfaces |
I am not totally confident about it but my first guess is that it is not
possible. Because all data type "in" functions expect a char* as argument
from the world outside.
--Imad
www.EnterpriseDB.com
On 1/25/07, Shoaib Naazir <je_shoaib(at)hotmail(dot)com> wrote:
>
> Hi,
> I am working on an application using PostgreSQL. I need to send date to
> PostgreSQL in binary format using the libpq interface. I have walked through
> the PostgreSQL code base, did find some reference to the date/time binary
> format but didn't get the exact format. To much code to digest in one parse
> :).
> Can you please provide me with any good reference to the exact binary
> format dbserver expect for date/time. I just can't use the text format :(.
> Any reference material, paper, web page or a mail specifying the exact
> binary date/time format will do.
>
> Thanks in advance. I really appreciate your time.
>
> regards,
> Shoaib Naazir.
>
>
> *Artificial intelligence is no match for natural
> stupidity. *
>
>
> ------------------------------
> Get into the holiday spirit, chat with Santa on Messenger. Ho-Ho-Ho!<http://imagine-windowslive.com/minisites/santabot/default.aspx?locale=en-us>
>