Thread: Query regarding PostgreSQL date/time binary format for libpq
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.
Get into the holiday spirit, chat with Santa on Messenger. Ho-Ho-Ho!
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.
stupidity.
Get into the holiday spirit, chat with Santa on Messenger. Ho-Ho-Ho!
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
--Imad
www.EnterpriseDB.com
On 1/25/07, Shoaib Naazir <je_shoaib@hotmail.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!