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

Reply via email to