Media Summary: This short video shows how to create a new date/time field containing date data from another field that is not in the date format. Select Case datename(WEEKDAY,getdate()) WHEN 'Sunday' THEN 1 WHEN 'Monday' THEN 2 WHEN 'Tuesday' THEN 3 WHEN ...
Sql Convert Day Number To - Detailed Analysis & Overview
This short video shows how to create a new date/time field containing date data from another field that is not in the date format. Select Case datename(WEEKDAY,getdate()) WHEN 'Sunday' THEN 1 WHEN 'Monday' THEN 2 WHEN 'Tuesday' THEN 3 WHEN ...