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

Reply via email to