Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 7D8159FB478
	for <pgsql-interfaces-postgresql.org@postgresql.org>;
	Thu, 25 Jan 2007 09:08:59 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 06111-02 for
	<pgsql-interfaces-postgresql.org@postgresql.org>;
	Thu, 25 Jan 2007 09:08:49 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from bay0-omc1-s18.bay0.hotmail.com (bay0-omc1-s18.bay0.hotmail.com
	[65.54.246.90]) by postgresql.org (Postfix) with ESMTP id 64F219FA4F7
	for <pgsql-interfaces@postgresql.org>;
	Thu, 25 Jan 2007 09:08:53 -0400 (AST)
Received: from BAY124-W14 ([207.46.11.177]) by bay0-omc1-s18.bay0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.2668);
	Thu, 25 Jan 2007 05:08:47 -0800
X-Originating-IP: [203.215.160.146]
X-Originating-Email: [je_shoaib@hotmail.com]
Message-ID: <BAY124-W14A44C6A2BDB40EC97B2F381A30@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_ff089a8d-ffa6-4486-9499-f489fced42e7_"
From: Shoaib Naazir <je_shoaib@hotmail.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Query regarding PostgreSQL date/time binary format for libpq
Date: Thu, 25 Jan 2007 13:08:47 +0000
MIME-Version: 1.0
X-OriginalArrivalTime: 25 Jan 2007 13:08:47.0856 (UTC)
	FILETIME=[F333B700:01C74081]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.964 tagged_above=0 required=5 tests=BAYES_40,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, HTML_30_40, HTML_IMAGE_ONLY_12,
	HTML_MESSAGE, SPF_PASS
X-Spam-Level: ***
X-Archive-Number: 200701/41
X-Sequence-Number: 6419

--_ff089a8d-ffa6-4486-9499-f489fced42e7_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 thr=
ough the PostgreSQL code base, did find some reference to the date/time bin=
ary format but didn't get the exact format. To much code to digest in one p=
arse :).   Can you please provide me with any good reference to the exact b=
inary format dbserver expect for date/time. I just can't use the text forma=
t :(. Any reference material, paper, web page or a mail specifying the exac=
t binary date/time format will do. Thanks in advance. I really appreciate y=
our time. regards,Shoaib Naazir.
Artificial intelligence is no match for natural stupidity.=20
_________________________________________________________________
Get into the holiday spirit, chat with Santa on Messenger.
http://imagine-windowslive.com/minisites/santabot/default.aspx?locale=3Den-=
us=

--_ff089a8d-ffa6-4486-9499-f489fced42e7_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>Hi,<BR>&nbsp;&nbsp; I am working on an application using PostgreSQL. =
I need to send date to PostgreSQL in binary format using the libpq interfac=
e. 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 cod=
e to digest in one parse :).<BR>&nbsp;&nbsp; Can you please provide me with=
 any good reference to the exact binary format dbserver expect for date/tim=
e. 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.<BR>&nb=
sp;<BR>Thanks in advance. I really appreciate your time.<BR>&nbsp;<BR>regar=
ds,<BR>Shoaib Naazir.<BR><BR><BR>
<DIV><STRONG>Artificial intelligence is no match for natural <BR>stupidity.=
 <IMG height=3D19 src=3D"http://graphics.hotmail.com/i.p.emthup.gif" width=
=3D19></STRONG></DIV><BR><br /><hr />Get into the holiday spirit, chat with=
 Santa on Messenger.=A0 <a href=3D'http://imagine-windowslive.com/minisites=
/santabot/default.aspx?locale=3Den-us' target=3D'_new'>Ho-Ho-Ho!</a></body>
</html>=

--_ff089a8d-ffa6-4486-9499-f489fced42e7_--