DATE CONVERSIONS
STRING 2 DATE SourceFormat Example yyyy.mm.dd SELECT convert(datetime, ‘2021.03.30’, 102) dd.mm.yyyy SELECT convert(datetime, ‘30.03.2021’, 104)
Datum
T-SQL DATA CONVERSION
Allgemeines In T-SQL-Umfeld gibt es 2 Konvertierungs-Funktionen: CAST (SQL-92 compatible) CONVERT Know When to Use
SQL & UNIXTIME
Unixtime 2 DateTime Select dateadd(S, [unixtime], ‘1970-01-01′) From [Table] DateTime 2 UnixTime Select (datediff(second,’1970-01-01 00:00:00.000’,[TimeStamp]))
