Script to return datetime as just date

You can return the date as a string (varchar) in whatever date format you like by adding a 'style' to the CONVERT statement. Exmaples of style values are (two left hand columns):1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 - dd […]

3.33 (3)

2005-02-18 (first published: )

186 reads

Blogs

Logical crossroads in Azure Data Factory (IF and Filter operations)

By

(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Storage Tiers What SQL Server DBAs Need to Know

By

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...

Read the latest Blogs

Forums

Trying to get output of PRINT command after select in Transaction

By boughrogers

Hi I am looking to select the output of the data that I plan...

Patches

By mtz676

How do I generate a report which tells me if my sqlservers are upto...

Use Domain Account for SQL Server service on Linux

By S_DBA

Currently, while installing SQL server we use a local linux account to run the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers