Baan SQL Group by datetime but ignore minute and hour
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
I am trying to find out how to get the unique days in a table using Baan SQL, I can do it in T-SQL by ignoring hour/minute and just extracting the date in a like '2016/12/16' format.
convert(varchar, d.log_date, 101) as log_date,
convert(varchar, d.log_date, 101)
Can please somebody point me to the right direction?