In this article, we are going to explore different SQL Convert Date formats to use to write SQL queries.
SQL Server provides so many options that you can use to format a date/time string in SQL.
An early consideration is the actual date/time required. The most common is the current date/time running getdate().
SQL Statement | Format | Date |
| select convert(varchar, getdate(), 1) | mm/dd/yy | 02/12/22 |
| select convert(varchar, getdate(), 2) | yy.mm.dd | 22.02.12 |
| select convert(varchar, getdate(), 3) | dd/mm/yy | 12/02/22 |
| select convert(varchar, getdate(), 4) | dd.mm.yy | 12.02.22 |
| select convert(varchar, getdate(), 5) | dd-mm-yy | 12-02-22 |
| select convert(varchar, getdate(), 6) | dd-Mon-yy | 12 Feb 22 |
| select convert(varchar, getdate(), 7) | Mon dd, yy | Feb 12, 22 |
| select convert(varchar, getdate(), 8) | hh:mm:ss | 11:03:00 |
| select convert(varchar, getdate(), 9) | Mon dd yyyy hh:mm:ss:nnn AM/PM | Feb 12 2022 11:03:00:417AM |
| select convert(varchar, getdate(), 10) | mm-dd-yy | 02-12-22 |
| select convert(varchar, getdate(), 11) | yy/mm/dd | 22/02/12 |
| select convert(varchar, getdate(), 12) | yymmdd | 22/02/12 |
| select convert(varchar, getdate(), 13) | dd Mon yyyy hh:mm:ss:nnn AM/PM | 12 Feb 2022 11:03:00:417 |
| select convert(varchar, getdate(), 14) | hh:mm:ss:nnn | 11:03:00:417 |
| select convert(varchar, getdate(), 20) | yyyy-mm-dd hh:mm:ss | 2022-02-12 11:06:50 |
| select convert(varchar, getdate(), 21) | yyyy-mm-dd hh:mm:ss:nnn | 2022-02-12 11:14:12 |
| select convert(varchar, getdate(), 22) | mm/dd/yy hh:mm:ss AM/PM | 02/12/22 11:14:21 AM |
| select convert(varchar, getdate(), 23) | yyyy-mm-dd | 2022-02-12 |
| select convert(varchar, getdate(), 24) | hh:mm:ss | 11:14:29 |
| select convert(varchar, getdate(), 25) | yyyy-mm-dd hh:mm:ss:nnn | 2022-02-12 11:14:29 |
| select convert(varchar, getdate(), 100) | Mon dd yyyy hh:mm AM/PM | Feb 12 2022 11:14 AM |
| select convert(varchar, getdate(), 101) | mm/dd/yyyy | 02/12/2022 |
| select convert(varchar, getdate(), 102) | yyyy.mm.dd | 2022.02.12 |
| select convert(varchar, getdate(), 103) | dd/mm/yyyy | 12/02/2022 |
| select convert(varchar, getdate(), 104) | dd.mm.yyyy | 12.02.2022 |
| select convert(varchar, getdate(), 105) | dd-mm-yyyy | 12-02-2022 |
| select convert(varchar, getdate(), 106) | dd Mon yyyy | 12 Feb 2022 |
| select convert(varchar, getdate(), 107) | Mon dd, yyyy | Feb 12, 2022 |
| select convert(varchar, getdate(), 108) | hh:mm:ss | 11:35:05 |
| select convert(varchar, getdate(), 109) | Mon dd yyyy hh:mm:ss:nnn AM/PM | Feb 12 2022 11:35:05:937AM |
| select convert(varchar, getdate(), 110) | mm-dd-yyyy | 02-12-2022 |
| select convert(varchar, getdate(), 111) | yyyy/mm/dd | 2022/02/12 |
| select convert(varchar, getdate(), 112) | yyyymmdd | 20220212 |
| select convert(varchar, getdate(), 113) | dd Mon yyyy hh:mm:ss:nnn | 12 Feb 2022 11:40:06:220 |
| select convert(varchar, getdate(), 114) | hh:mm:ss:nnn | 11:40:06:220 |
| select convert(varchar, getdate(), 120) | yyyy-mm-dd hh:mm:ss | 2022-02-12 11:40:06 |
| select convert(varchar, getdate(), 121) | yyyy-mm-dd hh:mm:ss:nnn | 2022-02-12 11:40:06 |
| select convert(varchar, getdate(), 126) | yyyy-mm-dd T hh:mm:ss:nnn | 2022-02-12 11:40:06 |
| select convert(varchar, getdate(), 127) | yyyy-mm-dd T hh:mm:ss:nnn | 2022-02-12 11:40:06 |
| select convert(varchar, getdate(), 130) | dd mmm yyyy hh:mi:ss:nnn AM/PM | 11 ??? 1443 11:40:06:220AM |
| select convert(varchar, getdate(), 131) | dd mmm yyyy hh:mi:ss:nnn AM/PM | 11/07/1443 11:40:06:220AM |
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular
In this article, we have to show Create and Used PIPE in angular