To do this in SQL, you'd have to write one nasty big query to split this string up and convert those small pieces into large integers.

When working with dates and times in SQL Server, it’s common for formatting discrepancies to cause issues during query execution. To prevent errors, it’s crucial to ensure that date strings are ...