On 10/2/06 12:33 AM, Jonathan Vanasco wrote: > 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
Actually, I was referring to the distinction between "now" (the three character string, not a function call) and the function call now(). Postgres date/time columns understand "now" as a plain, quoted string (and treats it as you described). MySQL does not. MySQL does have a now() function, but that's not the same thing as the string "now" from the perspective of SQL generation. -John ------------------------------------------------------------------------- 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