Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT tblEmployees.id, tblEmployees.fName, tblEmployees.lName, tblEmployees.bDate,
- DATE() AS Today,
- DateAdd("d",1,DATE()) AS [NEXT DAY],
- DateAdd("ww",1,DATE()) AS [NEXT Week],
- DateAdd("yyyy",1,DATE()) AS [NEXT YEAR],
- DateDiff("yyyy",bDate,Today) AS Age,
- DatePart("d",bDate) AS dayPart,
- DatePart("m",bDate) AS monthPart,
- DatePart("yyyy",bDate) AS yearPart,
- DAY(DATE()) AS [DAY], MONTH(DATE()) AS [MONTH],
- YEAR(DATE()) AS yaer
- FROM tblEmployees;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
