Using the DATEDIFF function to select rows
I keep seeing people using CONVERT to convert a date to a varchar in order to do comparison or search queries. I haven't seen a situation yet where DATEDIFF can't be used.
2002-08-29
1,191 reads
Blogs
Daily Coping 1 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
PASS Virtual Summit 2020 Conference Sessions
By kleegeek
Whether you are a SQL Server Database Administrator or Infrastructure Architect, you should be...
Running Express Edition in a Container–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Internal Query Processor Error: The query processor could not produce a query pl
Is there a standard method for troubleshooting the below error? Internal Query Processor Error:...
How to extract string between variable characters?
Hi All, I've got a nasty column that I need to get the name...
Making 1 row from 2
I'm struggling a bit here. It seems easy, but I 'm not getting it....
Ask SSC