Re: Problems with seperator in DATETIME
Octavio Gomez wrote:
> >I'm trying to prepare 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
>
> 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
Good idea! This statement works fine, Thanks! But I still wonder, why
the DATETIME-Version does not...
Thanks to all who responded!
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