Modification date

[Ruslan Zasukhin]

On 20/3/07 12:56 AM, "Kim Kohen" <kim at webguide.com.au> wrote:

Hi Kim,

>>>> 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
> €€€€
> I'm still having problems with this. Using VStudio and I have a filed
> (datetime) with now() as the default value.

Still? 

Using 2.5.8 uploaded at Sunday?

I Just only have sent announce about final 2.5.8 build.

 
> During inserts I'm always returning  02/02/-4224 00:00:00:000. Is
> this likely a bug in VStudio or in the now() function?  I realise I
> could code around it but it seems it should work.

Yes it should work.

I remember that on prev week Ivan have reproduce your report and did some
fixes.

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