Informix syntax query

[lizzarrd]

Hi All,

Am very new to infomrix and was wondering if anyone could tell me what is wrong (syntax-wise) with the following query:
========================================
Select
DATE(transac_date) as Date,
, COUNT(*)
From
tb_transaction
Where
company_sn = 101
Group by
DATE(transac_date)
========================================

If I remove the DATE() function the query runs fine, but with the function it produces a syntax error message.

Any help here is greatly appreciated!!

L

 

[PHV]

Where is the syntax error ? the SELECT clause or the GROUP BY ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lizzarrd]

It seems that the error is in the Group by Clause.

 

[PHV]

Use this clause:
GROUP BY 1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lizzarrd]

so simple!! Thanks.