Formatting DateTime to Date in SQL SERVER

admin February 16, 2013 0 


Select convert(varchar(10),GetDate(),101)

Output: 04/16/2009



Select convert(varchar(10),GetDate(),103)

Output: 16/04/2009

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I agree to have my personal information transfered to Mad Mimi ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Related posts:

No related posts.

More Stories

sql-server_logo

Replace SQL Server new line with HTML

admin September 9, 2021 0

Rounding a number to 2 decimal places in SQL SERVER

admin February 16, 2013 0

Finding duplicates with SQL?

admin February 15, 2013 0

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You may have missed

monitor screen with openai logo on black background

Simple File Manager in PHP By ChatGPT

admin December 17, 2023 0
man people woman hand

Customize input type=”text” datalist to show only last 10 saved values

admin October 8, 2023 0
holding a smartphone in front of an imac

15 best tips to create viral videos for TikTok

admin August 23, 2023 0
touch light wordpress theme mobile

15+ Top Mobile Themes For WordPress

admin December 4, 2021 0
guru able angular 2 template web

17 Of The Best Rated Angular 2 Website Templates

admin November 28, 2021 1