get day of week in sql server code example Example: datepart day of week SELECT DATENAME(DW,'2007-10-30');