On Thu, 25 May 2006, Jonathan Vanasco wrote:

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

no, the MySQL has no transaction support with time. its only within a statement:

Yeah, sorry, I meant start of statement vs. wallclock time. Both MySQL as of 5.0.13 and PostgreSQL since forever (AFAIK) give you a way to get the wallclock time, but their now() pegs the time at a different starting point.

Thanks for the correction.

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/



-------------------------------------------------------
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