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@notorand.it> wrote:
> From: Vincenzo Romano <vincenzo.romano@notorand.it>
> Subject: Re: Get Unix timestamp from SQL timestamp through libpq
> To: "Yan Cheng Cheok" <yccheok@yahoo.com>
> Cc: pgsql-general@postgresql.org
> 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@yahoo.com>:
> > 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@postgresql.org)
> > 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@notorand.it
> fix. +39 0823 454163 | skype. notorand.it
> fax. +39 02 700506964 | msn. notorand..it
> NON QVIETIS MARIBVS NAVTA PERITVS
>