V1 problem with select and timestamps

[Ruslan Zasukhin]

On 10/17/06 11:45 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

>> * try from Valentina Studio
>> 
>> * you work local or remote ?
> 
> Remote. Valentina Studio can not connect. I always get errors with vserver.

Ah yes, Vstudio cannot connect to v1 server.
 
> However, I changed my SQL to "WHERE BP_MEISOLsync_TS<'01.01.0001 00:00:00'"
> and that works, which is enough for me

Miracle.

I think I know. Most probably v1 do have the same bug for datetime
Which we have fix in 2.4 -- date/time values have few unused bits.
They was not zeroed, so they can be non-zero.


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