From: | Yan Cheng Cheok <yccheok(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Get Unix timestamp from SQL timestamp through libpq |
Date: | 2010-01-11 06:16:03 |
Message-ID: | 938588.91925.qm@web65716.mail.ac4.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Anisha Kaul | 2010-01-11 06:37:27 | Re: pgsql2shp usage |
Previous Message | Yan Cheng Cheok | 2010-01-11 03:45:01 | Re: Return Single Row Result After Inserting (Stored Procedure) |