Modification date

[Ruslan Zasukhin]

On 15/3/07 11:19 AM, "Kim Kohen" <kim at webguide.com.au> wrote:

> 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?

Ivan point that now() returns DateTime type

He say that 
        timeFld     = now()     okay
        datetimeFld = now()     okay
        dateFld     = now()     garbage.

He will check last point asap.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]