On Thu, 25 May 2006, Jonathan Vanasco wrote:

If you do create that, it would be really nice to implement it using postgres type NOW() behavior for mysql

ie: mysql NOW() is whenever a NOW() is executed. postgres NOW() is the transaction start time (though you can override with a standard function for the actual time).

In PostgreSQL the way to get wallclock time (not start of transaction time) is with timeofday().

MySQL as of version 5.0.13 has two different times as well, now() and sysdate(), for start of statement vs. start of transaction, as mentioned here:

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/
Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ...


-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to