Convert datetime to String using the CONVERT function in SQL Server

Source: Internet
Author: User

CONVERT (varchar (ten), date, 23)

1 02/22/06 CONVERT (varchar (), date, 1)

0 Feb 2006 4:26pm CONVERT (CHAR), Current_timestamp, 0)
1 02/22/06 CONVERT (CHAR (8), Current_timestamp, 1)
2 06.02.22 CONVERT (CHAR (8), Current_timestamp, 2)
3 22/02/06 CONVERT (CHAR (8), Current_timestamp, 3)
4 22.02.06 CONVERT (CHAR (8), Current_timestamp, 4)
5 22-02-06 CONVERT (CHAR (8), Current_timestamp, 5)
6 06 CONVERT (CHAR (9), Current_timestamp, 6)
7 Feb 22, 06 CONVERT (CHAR (Ten), Current_timestamp, 7)
8 16:26:08 CONVERT (CHAR (8), Current_timestamp, 8)
9 Feb 2006 4:26:08:020pm CONVERT (CHAR (+), Current_timestamp, 9)
10 02-22-06 CONVERT (CHAR (8), Current_timestamp, 10)
11 06/02/22 CONVERT (CHAR (8), Current_timestamp, 11)
12 060222 CONVERT (CHAR (6), Current_timestamp, 12)
13 2006 16:26:08:020 CONVERT (CHAR), Current_timestamp, 13)
14 16:26:08:037 CONVERT (CHAR (), Current_timestamp, 14)
20 2006-02-22 16:26:08 CONVERT (CHAR), Current_timestamp, 20)
21st 2006-02-22 16:26:08.037 CONVERT (CHAR (at), Current_timestamp, 21)
22 02/22/06 4:26:08 PM CONVERT (CHAR (), Current_timestamp, 22)
23 2006-02-22 CONVERT (CHAR (Ten), Current_timestamp, 23)
24 16:26:08 CONVERT (CHAR (8), Current_timestamp, 24)
25 2006-02-22 16:26:08.037 CONVERT (CHAR (at), Current_timestamp, 25)
100 Feb 2006 4:26pm CONVERT (CHAR), Current_timestamp, 100)
101 02/22/2006 CONVERT (CHAR (Ten), Current_timestamp, 101)
102 2006.02.22 CONVERT (CHAR (Ten), Current_timestamp, 102)
103 22/02/2006 CONVERT (CHAR (Ten), Current_timestamp, 103)
104 22.02.2006 CONVERT (CHAR (Ten), Current_timestamp, 104)
105 22-02-2006 CONVERT (CHAR (Ten), Current_timestamp, 105)
106 2006 CONVERT (CHAR (one), Current_timestamp, 106)
107 Feb 22, 2006 CONVERT (CHAR (), Current_timestamp, 107)
108 16:26:08 CONVERT (CHAR (8), Current_timestamp, 108)
109 Feb 2006 4:26:08:067pm CONVERT (CHAR (+), Current_timestamp, 109)
the 02-22-2006 CONVERT (CHAR), Current_timestamp,
111 2006/02/22 CONVERT (CHAR (Ten), Current_timestamp, 111)
112 20060222 CONVERT (CHAR (8), Current_timestamp, 112)
113 2006 16:26:08:067 CONVERT (CHAR), Current_timestamp, 113)
114 16:26:08:067 CONVERT (CHAR (), Current_timestamp, 114)
120 2006-02-22 16:26:08 CONVERT (CHAR), Current_timestamp, 120)
121 2006-02-22 16:26:08.080 CONVERT (CHAR (at), Current_timestamp, 121)
126 2006-02-22t16:26:08.080 CONVERT (CHAR (at), Current_timestamp, 126)
127 2006-02-22t16:26:08.080 CONVERT (CHAR (at), Current_timestamp, 127)
130 ???? 1427 4:26:08:080pm CONVERT (CHAR (+), Current_timestamp, 130)
131 24/01/1427 4:26:08:080pm CONVERT (CHAR), Current_timestamp, 131

Convert datetime to String using the CONVERT function in SQL Server

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.