Written by

Question Tamer Rajab · Apr 3, 2017

Weekend

#Caché

how to exclude weekend(Friday) in sql statement i trade use select datediff(WK,date1,date2) but not working even i chose (Dialect mssQL)

Thank You

Discussion (1)0

Sean Connelly · Apr 4, 2017

Not sure what your definition of a weekend is, this will exclude Sunday and Saturday...

SELECT *
FROM your_table
WHERE DATEPART('dw', date1) NOT IN (1, 7)

Just Friday...

SELECT *
FROM your_table
WHERE DATEPART('dw', date1) <> 6

0 0