Aktuelles Datum/Uhrzeit
ID | 290 |
---|---|
Link Reference | Not set |
Link Credits | Not set |
Link Technical Documentation | Not set |
PlCodelang | T-SQL |
PlGroup | Datum, Zeit |
PlItemTitle | Aktuelles Datum/Uhrzeit |
Code | DECLARE @newDT DATETIME SET @newDT = CAST('2021-01-01 01:23:45' AS DATETIME) SELECT FORMAT(GETDATE(), 'yyyy-MM-dd', 'En') SELECT FORMAT(GETDATE(), 'yyyy-MM-dd HH:mm:ss', 'En') |
Result Example | 2021-01-01 2021-01-01 01:23:45 |