Wednesday, October 22, 2014

SQL - How to get the day name of a date

select DATENAME( dw, CONVERT( date, getdate(), 103 ) ) as BDay

Replace getdate() with your field

No comments:

Post a Comment