Re: Problems with seperator in DATETIME
Eckebrecht v. Pappenheim 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
>
Hi,
on my box your example works fine. I have no problems with the
colons ":". Either this is a version specific problem or
someone maps your colons ":" to another character.
Bye
Stefan Weideneder