What is the most optimal short date to convert to in SQL Sever to use in a predicate.
I have a date 2013-06-11 15:06:27.000
and want to use the short date part 2013-06-11
in a predicate.
What would be the best short date to convert to in SQL Server for this purpose?
MSDN - Date convert
Select Convert(DateTime, Convert(VarChar, GetDate(), 12))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With