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

RMOUG Training Days in Denver

By

Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...

Daily Coping 7 Feb 2023

By

Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Read the latest Blogs

Forums

What are the alternatives of S3 Object Lambda?

By kwalampur

Hi all! AWS has a good example of how to manipulate the requested objects...

SQL Script plug-in

By dmarino324

Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...

Modify RDS page missing the Storage Autoscaling option

By jecobdruv

Hi folks, I have a single Postgres instance on RDS that in the past...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers