On Oct 1, 2006, at 1:10 PM, Uwe Voelker wrote:
> What do you mean by that? MySQL has 'NOW()' - how does that differ?
NOW() in mysql means 'now' as in the moment in time when 'now()' was
called
NOW() in pgsql means 'now' as in the moment in time where the
transaction that NOW() sits in was began . essentially, that means
that NOW() in pgsql can be used as a transaction id
NOW() in mysql is the equivalient of timeofday() in pgsql (though you
have to run it through a funciton to parse the text of timeofday into
a timestamp value )
I don't know if there is a transaction time start function in mysql.
in psuedocode:
pgsql:
begin;
select NOW()- 00:00
select timeofday()- 00:01
select NOW()- 00:00
select timeofday()- 00:02
rollback;
mysql
begin;
select NOW() - 00:00
select NOW() - 00:01
select NOW() - 00:02
rollback;
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
