yoy.be "Why-o-Why"

DATEPART: The 'real' datepart

2006-07-07 10:18  r475  coding  [permalink]

DATEPART: The 'real' datepart

similar to this, the code to 'get monday':

DATEADD([WEEK],DATEDIFF([WEEK],0,GETDATE()),0)
optionally on a different date than GETDATE() off course

twitter reddit linkedin facebook