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

191 reads

Blogs

Daily Coping 30 Nov 2021

By

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

Fail activity in Azure Data Factory and Why would I want to Fail

By

(2021-Nov-30) I heard a story about a young person who was asked why she was...

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

MSSQL Replication

By CliveG

Hi, I am using the following: 2 x freeradius servers on Redhat 2 x...

Find matching parenthesis

By ktflash

Ahoi, i recently switched from SSMS 17 to 18 due to a server upgrade....

Check user's group for default parameters

By maniqwils

I have a request to change the default value of a parameter based on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers