2021-02-04
687 reads
DateDiff
2020-02-27
14,806 reads
Work around for calculating age using the SQL Server DateDiff function
Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
2012-05-23
4,752 reads
Blogs
Updated Pluralsight Course – Managing the Kubernetes API Server and Pods
My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...
Daily Coping 11 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us...
Forums
Does lastBatch in sp_who2 really mean the time the user execute a SQL batch
I usually use sp_who2 see who is connected and is active in the SQL...
How to take a value hhmmss from the file
Hello, I have a file in this format "Vendor_ABC_Pro_20210422T205535". In this file, we have...
Ask SSC