|
Posted by ZeldorBlat on 03/29/07 15:57
On Mar 28, 1:03 pm, "Steve" <no....@example.com> wrote:
> btw, i used $stamp for both fields being set as using NOW() (even if you got
> your query to work) would set them to two different values even though the
> transaction happened at the same time.
Are you sure about that? From <http://dev.mysql.com/doc/refman/4.1/en/
date-and-time-functions.html>:
<snip>
Functions that return the current date or time each are evaluated only
once per query at the start of query execution. This means that
multiple references to a function such as NOW() within a single query
always produce the same result.
</snip>
Navigation:
[Reply to this message]
|