Are you available for a conference call on Wednesday July 5 at 10:30 AM?
SELECT TOP 1
CAST ( DATEADD ( YEAR, sa_rowgenerator.row_num, '2011-07-05' ) AS DATE ) AS "Next Wednesday July 5"
FROM sa_rowgenerator ( rstart = 1, rend = 7, rstep = 1 )
WHERE DAYNAME ( "Next Wednesday July 5" ) = 'Wednesday'
ORDER BY sa_rowgenerator.row_num;
Next Wednesday July 5
'2017-07-05'
No comments:
Post a Comment