1 | select convert(varchar, getdate(), 1) | 01/07/08 |
2 | select convert(varchar, getdate(), 2) | 08.01.07 |
3 | select convert(varchar, getdate(), 3) | 07/01/08 |
4 | select convert(varchar, getdate(), 4) | 07.01.08 |
5 | select convert(varchar, getdate(), 5) | 07-01-08 |
6 | select convert(varchar, getdate(), 6) | 07 Jan 08 |
7 | select convert(varchar, getdate(), 7) | Jan 07, 08 |
10 | select convert(varchar, getdate(), 10) | 01-07-08 |
11 | select convert(varchar, getdate(), 11) | 08/01/07 |
101 | select convert(varchar, getdate(), 101) | 01/07/2008 |
102 | select convert(varchar, getdate(), 102) | 2008.01.07 |
103 | select convert(varchar, getdate(), 103) | 07/01/2008 |
104 | select convert(varchar, getdate(), 104) | 07.01.2008 |
105 | select convert(varchar, getdate(), 105) | 07-01-2008 |
106 | select convert(varchar, getdate(), 106) | 07 Jan 2008 |
107 | select convert(varchar, getdate(), 107) | Jan 07, 2008 |
110 | select convert(varchar, getdate(), 110) | 01-07-2008 |
111 | select convert(varchar, getdate(), 111) | 2008/01/07 |
TIME FORMATS | ||
8 or 108 | select convert(varchar, getdate(), 8) | 18:12:39 |
9 or 109 | select convert(varchar, getdate(), 9) | Jan 7 2008 6:13:02:140PM |
14 or 114 | select convert(varchar, getdate(), 14) | 18:13:21:093 |
You can also format the date or time without dividing characters, as well as concatenate the
date and time string:
Sample statement | Output |
select replace(convert(varchar, getdate(),101),'/','') | 01072008 |
select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','') | 01072008181409 |
No comments:
Post a Comment