libpq binary data
От | thilo@riessner.de |
---|---|
Тема | libpq binary data |
Дата | |
Msg-id | 3808965.tNLrlL6qTR@thilo.site обсуждение исходный текст |
Ответы |
Re: libpq binary data
Re: libpq binary data |
Список | pgsql-interfaces |
Hello, I try to get the epoch value of a date via the PQexecParams(conn, "SELECT extract(epoch from date + time) as epoch, content FROM daten .....); In that database, the timestamp ist stored in the two fields date and time. I want to get this data in binary form. The PQfsize(res, 1); tells me, that the size of the returned data is 8 byte (in contrast to the standard size of epoch, which is meant to be 4 byte) I don't manage to get the epoch valule (seconds since 1970) from that returned value. After ntohll (which I wrote as a wrapper around ntohl for long int, see below) it is a very huge value (4743709917079142400) but it should be 1412179252 as I get it from the psql interface, when I type in the same command. What am I missing or doing wrong? Thanks for any help in advance Thilo unsigned long int ntohll(long int x) {if (ntohl(1) == 1) return x;else return (long int) (ntohl((int)((x << 32) >> 32))) << 32 | (long int)ntohl(((int)(x >> 32))); }
В списке pgsql-interfaces по дате отправления: