Modification date

[Kim Kohen]

G'day Ruslan,

> You can use function NOW().
> May be this will work in 2.5.6:
>     UPDATE ...  SET fld = NOW()
••••
I played with the now() function today to test something. Added a  
date field to a table and set the default value to now(). Creating a  
new row returned 00/00/2000.

I assumed (obviously wrongly) this would return the equivalent of the  
RB SQLDateTime function;  YYYY-MM-DD HH:MM:SS  I'm just looking for a  
simple way to autoenter the creation date and this seemed like the  
solution. I searched the wiki and couldn't find any reference to now 
(). Is it documented anywhere?

cheers

kim