X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DBB4053519 for ; Thu, 7 Apr 2005 22:05:15 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11468-03 for ; Thu, 7 Apr 2005 21:05:07 +0000 (GMT) Received: from firewall.innovision.com (64-126-22-242.biztype2.everestkc.net [64.126.22.242]) by svr1.postgresql.org (Postfix) with ESMTP id B6C8F536CA for ; Thu, 7 Apr 2005 22:05:05 +0100 (BST) Received: from [10.10.10.189] (unverified [10.10.10.189]) by innovision.com (SurgeMail 2.2g3) with ESMTP id 2614 for ; Thu, 07 Apr 2005 16:05:06 -0500 Message-ID: <4255A00F.1010409@innovision.com> Date: Thu, 07 Apr 2005 16:03:11 -0500 From: Marvin Bellamy User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: What is the binary format for timestamps? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server: High Performance Mail Server - http://surgemail.com X-Authenticated-User: mbellamy@innovision.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/22 X-Sequence-Number: 5438 I'm trying to read/write timestamps as binary data, but I'm getting garbage. It looks like there are 8 bytes of timestamp data (if I read the headers correctly), which I had assumed was the time in millis from the PostgreSQL epoch, but my values are way off. I wrote what I thought was valid data to my timestamp columns, but my queries in the psql console show (epoch?) for each one. When I read the binary content back, I'd expect to get 0s, but I get some non-zero values. -- Marvin Keith Bellamy Software Engineer Innovision Corporation 913.438.3200