On 11 Jan 2010, at 7:16, Yan Cheng Cheok wrote: > 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.
The format of that "timestamp" you're referring to is dependant on client and server settings (locale among others). If you go this way make sure you specify the format when making the connection. Another option is to add an extra epoch column to your result-row and return that row instead of the original row. You'd have to change the return type to include the extra column of course (see RETURNS TABLE in the docs). Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4b4b0e7a10733449211764! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
