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