View Single Post
Old 16th December 2016, 22:34
eric.dizon's Avatar
eric.dizon eric.dizon is offline
Senior Member
Join Date: Feb 2012
Posts: 151
eric.dizon is on a distinguished road
Baan: ERP LN - DB: MS SQL - OS: 2003
Baan SQL Group by datetime but ignore minute and hour
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: None/Unknown


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,
group by
convert(varchar, d.log_date, 101)

Can please somebody point me to the right direction?

Reply With Quote