Not working. strftime is use to convert date and time to a string. 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, 3:25 PM > 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
