Hi Pepole,
I am new to db2. I am trying to write a query that group by date(create_time). create_time is a timestamp.

Consider the query below.

select date(create_time)
from A
Group by date(create_time)

I get an error saying -- Illegal symbol "("
How do i get this working????

Thanks in advance

From where are you trying to execute your sql? In case you are doing it from a shell it might be the case that the shell interprets (. Example:

db2 select date(....) ...

might not work, try instead

db2 "select date(....) ..."


HTH
/Lennart

I am executing this query from QMF. I tried "" around the query but it won't work.

AFAIK, upto V7 , you cannot use a function in the group by ..

V8 introduces this feature ..



HTH

Sathyaram

Hi

Try:

select datum from
(select date(create_time) as datum
from A)
as a
Group by datum