git-varunpatel
/ gcloud-cheat-sheet.md
Created
April 18, 2024 08:42
— forked from pydevops/gcloud-cheat-sheet.md
gcp gcloud cheat sheet
git-varunpatel
/ SQLDateUtility
Created
September 22, 2021 10:37
— forked from phatty/SQLDateUtility
SQL Date Utility
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| – Microsoft SQL Server T-SQL date and datetime formats | |
| – Date time formats – mssql datetime | |
| – MSSQL getdate returns current system date and time in standard internal format | |
| SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM) | |
| – Oct 2 2008 11:01AM | |
| SELECT convert(varchar, getdate(), 101) – mm/dd/yyyy - 10/02/2008 | |
| SELECT convert(varchar, getdate(), 102) – yyyy.mm.dd – 2008.10.02 | |
| SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy | |
| SELECT convert(varchar, getdate(), 104) – dd.mm.yyyy | |
| SELECT convert(varchar, getdate(), 105) – dd-mm-yyyy |