Hello,Tom！ Thanks for your answer. To invoid missing something of the timestamp, i just copy the tm2timestamp func
intomy program.(Of course, some other related functions are copied, too), result is still refusing me.
What i need is: 41A7 7DBA D400 0000 stands for "2006-03-30 18:18:18" ( 41A7 7DBA D400 0000 is got from the Copy to
File)
When using tm2timestamp, result is:
if define HAVE_INT64_TIMESTAMP
result is: 4E66 E642 0030 C274
if not define HAVE_INT64_TIMESTAMP
{ if define INT64_IS_BUSTED result is: 6972 2142 0000 00DB if not define INT64_IS_BUSTED result is: 4221 7269 DB00
0000
}
So, maybe I forget to define something??
/******************************************************************************************************
* my codes
*
*/
my program is listed:
time_t time = 1143713898;
struct tm* tmField = gmtime(&time); // I know that struct tm dislikes the struct tm in "time.h"
tmField->tm_year += 1900;
tmField->tm_mon += 1; // So tmFiled is same as pg_tm
int tzp = 8;
char buffer[256];
timestamp timestampField ;
tm2timestamp(tmField,0,&tzp,×tampField);
timestamp_send(timestampField,buffer); // I changed some codes here, to get the binary format of timestamp
/*********************************************************************************************************/
so ,what switch should i turn on?
======= 2006-04-18 21:47:42 You Wrote：=======
>"energumen@buaa.edu.cn" <energumen@buaa.edu.cn> writes:
>> 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.
>
>No, it's seconds times 1000000, not times 2^32.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>.
= = = = = = = = = = = = = = = = = = = =