V1 problem with select and timestamps

[Florian Bogeschdorfer]

> >
> > c= valselectreturncursor("SELECT BP_MEISOLsync_TS FROM
> > buchungen_pointstable")
> > put valgetallrecordsofcursor(c)
> >
> > -- [[#BP_MEISOLsync_TS: "00.00.0000 00:00:00"], [#BP_MEISOLsync_TS:
> > "00.00.0000 00:00:00"]]
> >
> >
> > So the timestamp is all zeros, ok?
> 
> ok
> 
> > Now I try to find timestamps with all zeros:
> >
> > c= valselectreturncursor("SELECT BP_MEISOLsync_TS FROM
> buchungen_pointstable
> > WHERE BP_MEISOLsync_TS='00.00.0000 00:00:00'")
> >
> > put valgetallrecordsofcursor(c)
> >
> > --[]
> >
> > Zero results? Impossible. Where is the problem?
> 
> * May be in fact they are NULL ?

The field is not nullable. The fields have the value that Valentina would
set for them by standard on record creation, which as shown by V4MD is all
zeros.

> 
> * may be you have other date format for db.
>     although unlikely you have YMD
> 
> * try from Valentina Studio
> 
> * you work local or remote ?

Remote. Valentina Studio can not connect. I always get errors with vserver.

However, I changed my SQL to "WHERE BP_MEISOLsync_TS<'01.01.0001 00:00:00'"
and that works, which is enough for me

Best, Florian

>