Gestriges Datum

ID279
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangT-SQL
PlGroupDatum, Zeit
PlItemTitleGestriges Datum
CodeSELECT GetDate()
SELECT DATEADD(d, -1, GetDate())

SELECT GetDate()-1
Result Example

2012-01-17 08:15:45 2012-01-16 08:15:45 2012-01-16 08:15:45