Aktuelles Datum/Uhrzeit

ID290
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangT-SQL
PlGroupDatum, Zeit
PlItemTitleAktuelles Datum/Uhrzeit
CodeDECLARE @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