Home Forums SQL Server 2008 SQL Server 2008 - General convert date to string then grab parts of the string RE: convert date to string then grab parts of the string
Ed Wagner
SSC Guru
Points: 287024
More actions
October 24, 2016 at 10:57 am
#1908424
YB really hit the nail on the head. Depending on what you're trying to do, the DATEPART function can perform quite well. It's covered in Books Online at https://msdn.microsoft.com/en-us/library/ms174420.aspx.
Tally Tables - Performance PersonifiedString Splitting with True PerformanceBest practices on how to ask questions