SQL Function: DATE()

Definition:

Convert provided string into date and Return date.

---

Command Syntax:

DATE(string)

---

Command Example:

Table STUDENT

SID	SNAME	DOBYEAR	DOBMONTH	DOBDAY
010122	Chris Wong	2011	02	01
010142	Nico Lin	2011	08	21
010133	Amy Chan	2010	03	06

Input:

SELECT SNAME,DATE(DOBYEAR+'-'+DOBMONTH+'-'+DOBDAY) AS DOB FROM STUDENT ORDER BY DOB DESC;

Output:

SNAME	DOB
Nico Lin	2011-08-21
Chris Wong	2011-02-01
Amy Chan	2010-03-06

---

‘Just a date’By secondary 6 student