This is a follow-on to info's script to strip the time portion of a datetime or smalldatetime, leaving only the date. I found info's script interesting! When I had to do this I converted the date to varchar and back again instead of to float. Seems to work fine for me.
2003-04-03
123 reads
One feature that I have been waiting for years! The new announcement around optimize...
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers