Technical Article

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: )

190 reads

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

Connect to PostgreSQL as an External Data Source using PolyBase

By JerodJ

Comments posted to this topic are about the item Connect to PostgreSQL as an...

Growing and Keeping Up

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Growing and Keeping Up

Third Party VDI Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Third Party VDI Backup

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers