Modification date

[Ruslan Zasukhin]

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

Hi Kim,

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

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:reference

>From here look at 

    Date Time functions


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