Re: UTC date

Posted in 2004

Jonathan Leffler — Thu, 13 May 2004 05:11:38 GMT — source: Usenet: comp.databases.informix

Vijay Kumar wrote: > Please let me know what is UTC date in informix... It is not clear what information you are seeking. Please ask again, stating more clearly what it is you wish to do. For example: * I wish to take a DATETIME YEAR TO SECOND value in local time and convert it to the equivalent UTC value. * I want to get hold of the system time as the number of seconds since 1970-01-01 00:00:00+00:00. * I want to determine the elapsed time for a stored procedure, but I get the same time from CURRENT at the beginning and the end of the procedure, even though I know it takes over an hour to complete. Or something else... Answers to most of the above are obtainable by Googling at groups.google.com. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/