Hi,

I am using a HP Tandem Non Stop SQL Database (... it's not my choice!!!) and whant to compare a field MUTDATZEIT of type DATETIME with an input specific value given in argument...

select * from MYTABLE where MUTDATZEIT < '2000-01-01 00:00:00'

of course writting this i get an error cannot compare DATETIME with CHARACTER,
i already tried:

< DATETIME '2000-01-01 00:00:00'
< DATETIME '2000-01-01 00:00:00' year to day
< TO_DATE('2000-01-01 00:00:00', 'YYYY-MM-DD HH:MMS')

HELPPPPPPPPPP !

I cannot find any documention on it on the web...

i am really blocked,

thanks for your help

Datetime format needs a colon ( : ) between the year and time. Also datetime string has to have same elements as field def.

Examples:

select * from MYTABLE where MUTDATZEIT < DATETIME '2000-01-01:00:00:00' YEAR TO SECOND;

select * from MYTABLE where MUTDATZEIT < DATETIME '2000-01-01' YEAR TO DAY;

You can type "help;" in SQLCI and get a fair amount of information on the command syntax.

-Alan