• Interests: Music, biking, travel, movies

Technical Article

Date Only

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

115 reads

Blogs

Daily Coping 3 Feb 2023

By

Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs

Forums

Coding Magic Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Coding Magic Values

How to Check previous data loaded records vs current day in a table

By Zond Sita

Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...

Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers