Subject Re: comparing the TIME part of a DATE field
Author duilio_fos
--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:

>notice that a full-stop (period, punkt..) isn't the
correct separator for time literals!!!

I have redefined the table with TIMESTAMP fields and changed the full
stop with a colon, but can see no difference at all with the former
behaviour, at least when querying data directly with Marathon.

>you need to use a TIME type,

it seems that this type does not exist in dialect 1, that I am using.

However, I have discovered that '30-12-99' is meant as 1899-12-30.

In other words, if I write my query as

"select * from shifts where start_time>='1899-12-30 20.00.00'"

ev works ok.

Thank you