1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Writing Functions and Stored Procedures in SQL Server
Connected

Bài tập

What was yesterday?

Create a function that returns yesterday's date.

Hướng dẫn

100 XP
  • Create a function named GetYesterday() with no input parameters that RETURNS a date data type.
  • Use GETDATE() and DATEADD() to calculate yesterday's date value.