man 3 strftime 2010/1/11 Yan Cheng Cheok <yccheok@xxxxxxxxx>: > I try already. Neither of them can accept string parameter, and convert them to unit timestamp (long). > > Thanks and Regards > Yan Cheng CHEOK > > > --- On Mon, 1/11/10, Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx> wrote: > >> From: Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx> >> Subject: Re: Get Unix timestamp from SQL timestamp through libpq >> To: "Yan Cheng Cheok" <yccheok@xxxxxxxxx> >> Cc: pgsql-general@xxxxxxxxxxxxxx >> Date: Monday, January 11, 2010, 2:58 PM >> Give a try to: >> >> man 2 time >> man 3 ctime >> >> >> 2010/1/11 Yan Cheng Cheok <yccheok@xxxxxxxxx>: >> > I know I can convert SQL timestamp to unix timestamp, >> using the following way. >> > >> > SELECT extract(epoch FROM now()); >> > >> > Now, I have a stored procedure function, which will >> directly return a table row to the caller. One of the row >> field is "timestamp" type. >> > >> > In my application, I am using libpq. I wish to use >> libpq functions (or any c/c++ function), to convert >> "2010-01-11 13:10:55.283" into unix timestamp. Off course, I >> can create another stored procedure named >> > >> > SQLTimestamp2UnixTimestamp >> > SELECT extract(epoch FROM $1); >> > >> > But I just wish to accomplish this task with a single >> c/c++ function call, without involving stored procedure. >> > >> > Any suggestion? Thanks! >> > >> > Thanks and Regards >> > Yan Cheng CHEOK >> > >> > >> > >> > >> > >> > -- >> > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> > To make changes to your subscription: >> > http://www.postgresql.org/mailpref/pgsql-general >> > >> >> >> >> -- >> Vincenzo Romano >> NotOrAnd Information Technologies >> cel. +39 339 8083886 | gtalk. vincenzo.romano@xxxxxxxxxxx >> fix. +39 0823 454163 | skype. notorand.it >> fax. +39 02 700506964 | msn. notorand..it >> NON QVIETIS MARIBVS NAVTA PERITVS >> > > > > > -- Vincenzo Romano NotOrAnd Information Technologies cel. +39 339 8083886 | gtalk. vincenzo.romano@xxxxxxxxxxx fix. +39 0823 454163 | skype. notorand.it fax. +39 02 700506964 | msn. notorand.it NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
