On May 25, 2006, at 6:27 PM, Jon Jensen 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:
sysdate vs. sleep within a statement
mysql> select sysdate(), sleep(1), sysdate();
| 2006-05-25 18:37:35 | 0 | 2006-05-25 18:37:36 |
mysql> select now(), sleep(1), now();
| 2006-05-25 18:37:49 | 0 | 2006-05-25 18:37:49 |
sysdate vs sleep within a transaction
mysql> begin;
mysql> select NOW();
| 2006-05-25 18:40:07 |
mysql> select sysdate();
| 2006-05-25 18:40:11 |
mysql> select NOW();
| 2006-05-25 18:40:14 |
mysql> select sysdate();
| 2006-05-25 18:40:18 |
mysql> rollback;
the postgres way would give all calls to now the timestamp as
generated @ begin
| - - - - - - - - - - - - - - - - - - - -
| RoadSound.com / Indie-Rock.net
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - -
-------------------------------------------------------
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