Re: Problems with seperator in DATETIME
Eckebrecht wrote:
>
>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
>
Try this other way
SELECT Datumbeginn,OldId FROM leistung WHERE Datumbeginn >
EXTEND("1998-07-20 00:00:02", YEAR TO SECOND)
Octavio Gomez
sogomez@hotmail.com
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com