View Single Post
  #1  
Old 16th December 2016, 23: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

Hi,

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.
T-SQL
select
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?

Regards,
Eric
Reply With Quote