Re: biginteger to timestamp
| От | LiveShell |
|---|---|
| Тема | Re: biginteger to timestamp |
| Дата | |
| Msg-id | 928fe9b50607200241pea3a0bej11083ebd45dae8d4@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: biginteger to timestamp ("hubert depesz lubaczewski" <depesz@gmail.com>) |
| Ответы |
Re: biginteger to timestamp
Re: biginteger to timestamp |
| Список | pgsql-admin |
hi hubert
actally i have UNIX time and that is in 1153222974 format. and i m using C api to insert this time in a column whose type is timestamp.
so now can u tell me .... how can i convert it to timestamp and insert into the timestamp column.
On 7/20/06, hubert depesz lubaczewski <depesz@gmail.com> wrote:
On 7/20/06, LiveShell < liveshell@gmail.com> wrote:Hi all,
I want to convert biginteger and integer data type to timestamp data type.
Can any body tell me how to convert??and what is in this biginteger?
is it something like:
20060720113254::bigint
or rather something like "seconds from epoch"?
or something totally different?
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz
В списке pgsql-admin по дате отправления: