Guruji Point - Code You Want To Write

  • Home
  • Asp.Net
  • WCF
  • SQL
  • Type Script
  • AngularJS
  • Tech News
  • Blog
  • Earn Online

Sunday, 19 March 2017

Different DateTime Formats In SQL

 No comments   



Introduction

In this post i will explain about different commonly used  Date-Time format's in SQL server with example. You can learn how to format date and time by many ways in SQL server for your different requirements.

Date Formats In SQL
Date Format
Expression
Output
MM/DD/YY
SELECT CONVERT(VARCHAR(8), GETDATE(), 1)
03/19/17
MM/DD/YYYY
SELECT CONVERT(VARCHAR(10), GETDATE(), 101)
03/19/2017
MM-DD-YY
SELECT CONVERT(VARCHAR(8), GETDATE(), 10)
03-19-17
MM-DD-YYYY
SELECT CONVERT(VARCHAR(10), GETDATE(), 110)
03-19-2017



DD/MM/YY
SELECT CONVERT(VARCHAR(8), GETDATE(), 3)
19/03/17
DD/MM/YYYY
SELECT CONVERT(VARCHAR(10), GETDATE(), 103)
19/03/2017
DD.MM/YY
SELECT CONVERT(VARCHAR(8), GETDATE(), 4) 
19.03.17
DD.MM/YYYY
SELECT CONVERT(VARCHAR(10), GETDATE(), 104)
19.03.2017
DD-MM-YY
SELECT CONVERT(VARCHAR(8), GETDATE(), 5)
19-03-17
DD-MM-YYYY
SELECT CONVERT(VARCHAR(10), GETDATE(), 105)
19-03-2017



YY.MM.DD
SELECT CONVERT(VARCHAR(8), GETDATE(), 2)
17.03.19
YYYY.MM.DD
SELECT CONVERT(VARCHAR(10), GETDATE(), 102)
2017.03.19
YY/MM/DD
SELECT CONVERT(VARCHAR(8), GETDATE(), 11)
17/03/19
YYYY/MM/DD
SELECT CONVERT(VARCHAR(10), GETDATE(), 111) 
2017/03/19



DD Mon YY
SELECT CONVERT(VARCHAR(9), GETDATE(), 6)
19 Mar 17
DD Mon YYYY
SELECT CONVERT(VARCHAR(11), GETDATE(), 106)
19 Mar 2017
Mon DD, YY
SELECT CONVERT(VARCHAR(10), GETDATE(), 7) 
Mar 19, 17
Mon DD, YYYY
SELECT CONVERT(VARCHAR(12), GETDATE(), 107) 
Mar 19, 2017

DateTime Formats In SQL
SELECT CONVERT(VARCHAR(8), GETDATE(), 108)
Output- 23:14:24 (HH:MI:SS)
 
SELECT CONVERT(VARCHAR(26), GETDATE(), 109)
Output- Mar 19 2017 11:14:24:107PM 
 
SELECT CONVERT(VARCHAR(24), GETDATE(), 113)
Output -  19 Mar 2017 23:18:02:463
 
SELECT CONVERT(VARCHAR(12), GETDATE(), 114)
Output- 23:22:15:270
 
SELECT CONVERT(VARCHAR(19), GETDATE(), 120)
Output- 2017-03-19 23:22:15 
 
SELECT CONVERT(VARCHAR(23), GETDATE(), 121)
Output- 2017-03-19 23:22:15.270
 
SELECT CONVERT(VARCHAR(23), GETDATE(), 126)
Output- 2017-03-19T23:22:15.270

  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Facebook Updates

Guruji Point

Categories

Comman table Expression in SQL Dynamic Grid Row IQueryable in c# Learn AngularJS Scope_Identity() Use of indexes comma seperated string in sql row_number() and dense_rank() salary table structure. while loop in sql why do we need cursor why tuple used

About Us

This blog is about the Programming ,Tech News and some intresting facts related Contents. Here you can find fundamental and expert level topic of programming languages very practically related to C# , Asp.Net ,Sql-Server, JavaScript, Jquery, WebServices And also Web-Api, WCF ,WPF, Angular Js.

Contact Us

Email Us - gurujipoints@gmail.com
Contact- 8077657477

Reach Us

Copyright © Guruji Point - Code You Want To Write