how can i get the binary format of timestamp?

Поиск
Список
Период
Сортировка
От energumen@buaa.edu.cn
Тема how can i get the binary format of timestamp?
Дата
Msg-id 20060418035829.3BEAD37F86@mx2.buaa.edu.cn
обсуждение исходный текст
Ответы Re: how can i get the binary format of timestamp?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
ifind 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,second32 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_TIMESTAMPpq_sendint64(&buf, timestamp);             
#elsepq_sendfloat8(&buf, timestamp);
#endifPG_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;
#elsen32 = (uint32) (i >> 32);
#endifn32 = 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?



В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Question on win32 semaphore simulation
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: question regarding pg_database.h and DatabaseRelationId