Articles 
Microsoft SQL Server T-SQL DateTimestamps
Microsoft SQL Server T-SQL DateTimestamps
Wednesday, 23 March 2011 13:36
- Windows XP SP3
- MS SQL Server Management Studio 2008
- SQL Server 2008 R2
- Regional Setting: London BST (British Summer Time)
Tuesday the 11th of October 2011 at 06:00am:
CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) 10/11/11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) 11.10.11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) 11/10/11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) 11.10.11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) 11-10-11 CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) 11 Oct 11 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7) Oct 11, 11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8) 06:00:00 CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9) Oct 11 2011 6:00:00.000AM CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10) 10-11-11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11) 11/10/11 CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12) 111011 CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13) 11 Oct 2011 06:00:00.000 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14) 06:00:00:000 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20) 2011-10-11 06:00:00 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21) 2011-10-11 06:00:00.000 CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22) 10/11/11 6:00:00 AM CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23) 2011-10-11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24) 06:00:00 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25) 2011-10-11 06:00:00.000 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100) Oct 11 2011 6:00AM CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101) 10/11/2011 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103) 11/10/2011 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104) 11.10.2011 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105) 11-10-2011 CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106) 11 Oct 2011 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107) Oct 11, 2011 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108) 06:00:00 CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109) Oct 11 2011 6:00:00:000AM CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110) 10-11-2011 CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111) 2011/10/11 CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112) 20111011 CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113) 11 Oct 2011 06:00:00:000 CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114) 06:00:00:000 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120) 2011-10-11 06:00:00:000 CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121) 2011-10-11 06:00:00.000 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 126) 2011-10-11T06:00:00 CONVERT(CHAR(19), CURRENT_TIMESTAMP, 127) 2011-10-11T06:00:00 CONVERT(CHAR(32), CURRENT_TIMESTAMP, 130) 14 ?? ?????? 1432 06:00:00:000AM CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131) 14/11/1432 06:00:00:000AMI originally got a list from databases.aspfaq.com but the convert numbers didn't correspond to the output formats. This is my list created within my environment and setup (see above).
| < Prev | Next > |
|---|
