how can i get the binary format of timestamp?

From: "energumen(at)buaa(dot)edu(dot)cn" <energumen(at)buaa(dot)edu(dot)cn>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: how can i get the binary format of timestamp?
Date: 2006-04-18 03:59:27
Message-ID: 20060418035829.3BEAD37F86@mx2.buaa.edu.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello:
I find that the real timestamp format(got from the file which is produced by copying binary to ) is different from what i find in timestamp_send func.

i do think that the binary format of a timestamp "2006-04-18 11:20:20" should be "44 2B B0 6A 00 00 00 00" standing for "secs:1143713898, usecs:0" but in fact it is:"41A7 7DBA D400 0000 "

timestamp is defined as int64 or float8, when it is defined as int64, it looks like timeval, first 32 bits for seconds,second 32 bits for usec.
and from the timestamp_send func, it just changes the first 32 bits to binary then combines the next 32 bits

/* codes from timestamp_send
*/

Datum
timestamp_send(PG_FUNCTION_ARGS)
{
Timestamp timestamp = PG_GETARG_TIMESTAMP(0);
StringInfoData buf;

pq_begintypsend(&buf);
#ifdef HAVE_INT64_TIMESTAMP
pq_sendint64(&buf, timestamp);
#else
pq_sendfloat8(&buf, timestamp);
#endif
PG_RETURN_BYTEA_P(pq_endtypsend(&buf));
}

/* codes from pq_sendint64
*/
void
pq_sendint64(StringInfo buf, int64 i)
{
uint32 n32;

/* High order half first, since we're doing MSB-first */
#ifdef INT64_IS_BUSTED
/* don't try a right shift of 32 on a 32-bit word */
n32 = (i < 0) ? -1 : 0;
#else
n32 = (uint32) (i >> 32);
#endif
n32 = htonl(n32);
appendBinaryStringInfo(buf, (char *) &n32, 4);

/* Now the low order half */
n32 = (uint32) i;
n32 = htonl(n32);
appendBinaryStringInfo(buf, (char *) &n32, 4);
}

so i do think that the binary format of a timestamp "2006-04-18 11:20:20" should be "44 2B B0 6A 00 00 00 00" standing for "secs:1143713898, usecs:0"

but in fact it is:" 41A7 7DBA D400 0000 " , i don't know why.

maybe, i have looked into a wrong func, then which is the right one?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-04-18 08:13:58 Re: question regarding pg_database.h and DatabaseRelationId
Previous Message Bruce Momjian 2006-04-18 03:40:33 Re: schema-qualified SET CONSTRAINTS