Over the years while working with SQL Server, I found a safe way of converting string to date time value to be used in SQL. It will have zero risk of being parsed in WHERE clause or cause any performance issues.
Examples:
Convert to DATE type value
SELECT {d '2021-03-01'}
Convert to DATETIME type value
SELECT {ts '2021-03-01 06:10:00'}
No comments:
Post a Comment