• 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

What I’ve learned in my first 100 days with a consulting group

By

In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?

By

With Power BI continuing to get many great new features, including the latest in...

Daily Coping 30 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Working with T-SQL function AVG ()

By Manvendra Deo Singh

Comments posted to this topic are about the item Working with T-SQL function AVG...

The Useful Cloud Tags

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Useful Cloud Tags

Choosing Filestream

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Choosing Filestream

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers