• 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.

You rated this post out of 5. Change rating

2003-04-03

115 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Partition Large Tables needed

By sqlguy80

Hello Gurus, I have  a requirement and need to implement the solution quickly. SQL...

Deleting the Standby file

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting the Standby file

If You Build It, Will They Use Linux?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item If You Build It, Will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers