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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
