db2 cast timestamp to date

[faithful1]

How can I cast a timestamp to a date and group by that date. Currently I am using cast(fieldname as date), but I get duplicate dates when I group by that field.

 

[blom0344]

Hello Faithfull,

How does the DATE function work for you? (Should extract the date part from the timestamp) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[faithful1]

Thanks, I was using the Date function but then grouping by the original field! That's where the problem was. Thanks for the response.