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