CONVERT(VarChar(50), GETDATE(), 102) : Date Format « Date Timezone « SQL Server / T-SQL

1.	Aggregate Functions
2.	Analytical Functions
3.	Constraints
4.	Cursor
5.	Data Set
6.	Data Type
7.	Database
8.	Date Timezone
9.	Index
10.	Insert Delete Update
11.	Math Functions
12.	Select Query
13.	Sequence
14.	Store Procedure Function
15.	String Functions
16.	Subquery
17.	System
18.	Table
19.	Table Joins
20.	Transact SQL
21.	Transaction
22.	Trigger
23.	View
24.	XML

SQL Server / T-SQL » Date Timezone » Date Format

CONVERT(VarChar(50), GETDATE(), 102)





1>

2>

3> SELECT 'ANSI Date: ' + CONVERT(VarChar(50), GETDATE(), 102)

4> GO



-------------------------------------------------------------

ANSI Date: 2006.10.12



(1 rows affected)

1>

Related examples in the same category

1.	CONVERT(varchar, getdate(), 1(2,3,4,5,6))
2.	CONVERT(varchar,GETDATE(),108) 'hh:mm:ss'
3.	CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm'
4.	CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm'
5.	CONVERT(VarChar(50), GETDATE(), 104)
6.	CONVERT(VarChar(50), GETDATE(), 103)
7.	CONVERT(VarChar(50), GETDATE(), 100)
8.	CONVERT(VarChar(50), GETDATE(), 101)
9.	Reference Date data type as string (char)
10.	Format date: 'Mmm dd yyyy hh:mmdp'
11.	Format date: 'mm/dd/yyyy'

java2s.com | Contact Us | Privacy Policy

All other trademarks are property of their respective owners.