Date woes

[Ruslan Zasukhin]

On 26/3/07 4:04 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi,
> 
> I can confirm that exact the same problem arises when the date in
> Valentina is NULL
> 
> So problem is:
> 
> when a datefield in Valentina is set to 0000-00-00 (automatically by
> inserting a record without specifying the datevalue AND field IS NOT
> nullable) or when a date is NULL the getDate VDate function returns
> an strange date (0002-11-30)--> which I suppose is the last date you
> guys had a good night sleep :-)
> 
> The problem of course remains:
> 
> what should a getDate return when I receives a NULL or 0000-00-00 ?

By OO ideas it GetDate() returns an date oject. Right?

So if NULL is in db, then NULL also should be returned.

Kirill? 


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