Luis Cazares (8/29/2014)

---

Welsh Corgi (8/29/2014)

---

I want to do the Equivalent of the following SQL Select and return the result listed below:

SELECT CONVERT(DATE,GETDATE()) AS CurrentDate;

CurrentDate

2014-08-29

Thank you.

Equivalent in Oracle?

SELECT SYSDATE AS Datetype,

TRUNC(SYSDATE) AS NoTimeDate,

TO_CHAR(SYSDATE, 'YYYY-MM-DD') AS StringDate

FROM Dual;