Returns the current date.

Syntax

---

CURRENT_DATE([UTC])

Returns

---

DATE

Usage

---

The CURRENT_DATE function returns the current date. Use the UTC designation to indicate that the date returned should be a UTC (Coordinated Universal Time) value.


Examples

---

SELECT *
FROM Transactions
WHERE CAST(TransTimeStamp AS DATE) = CURRENT_DATE

SQL 2003 Standard Deviations

---

This function deviates from the SQL 2003 standard in the following ways: