Hello,

I an trying to group timestamp to whole days like this:

SELECT floor(CreatDate) as Date1, sum(Price) as sum1
FROM invoices
GROUP BY floor(CreatDate)

where CreatDate is timestamp

but it throws error:


ISC ERROR CODE:335544334

ISC ERROR MESSAGE:
conversion error from string "2004-01-26 09:02:09.0000"


I tried also

GROUP BY floor(CAST (CreatDate as timestamp))
GROUP BY floor(CAST (CreatDate as double precision))

but the same result.


Please how can I realize it ? Thanks