Modification date

[Ruslan Zasukhin]

On 15/3/07 12:37 PM, "Kim Kohen" <kim at webguide.com.au> wrote:

> G'day Ruslan,
> 
>> Ivan point that now() returns DateTime type
>> He say that
>>         timeFld     = now()     okay
>>         datetimeFld = now()     okay
>>         dateFld     = now()     garbage.
> €€€€
> Not what I'm seeing. In my tests I get garbage for all of them;
> datetime is returning  02/02/-4224 00:00:00:000, time is returning
> 00:00:00:000
> 
> Are these only meant to work for selects and not inserts?

Inserts and updates and WHERE all this should work

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