Problems with seperator in DATETIME

Hi, I'm trying to prepere a statement like SELECT Datumbeginn,OldId FROM leistung WHERE Datumbeginn > DATETIME (1998-07-20 00:00:02) YEAR TO SECOND all I get is 'Prepare error: SQL: -201: A syntax error has occurred.' The statement with DATETIME (1998-07-20 00) YEAR TO HOUR works fine, so I suppose, the seperator ':' between hour and minute ist wrong. But where is it set? ':' should be independent from any value of DBDATE or GL_DATE (neither is set). INFORMIX-OnLine Version 7.12.UC1 Thnks, Eckebrecht -- ------------------------------------------------------------------------ Eckebrecht von Pappenheim, network administration Verlag Heinz Heise GmbH & Co KG, Helstorferstr. 7, D-30625 Hannover, FRG EMail: evp@heise.de - Tel: +49 511 5352 242 - FAX: +49 511 5352 361