Aginity WorkBench Queries

select now() ;    –Select current date and time

select last_day(now());  –Select last date of the month

select add_months(now(),-1) ;  –Select current date time – 1 month

select age(now(),add_months(now(),-3) ); –Select difference between 2 dates

select * from KUDVENKAT.ADMIN.DATETEST WHERE HIREDDATE BETWEEN ADD_MONTHS(now(),-3) AND now()

— The above query select the employees who were hired in the past 3 months.

select T1.”EmployeeID”, T1.”EmployeeName”, T1.”ManagerID”, T2.”EmployeeName” FROM ADMIN.PART2EMPLOYEES T1
LEFT JOIN ADMIN.PART2EMPLOYEES T2 ON T1.”ManagerID” = T2.”EmployeeID”
ORDER BY T1.”ManagerID” DESC

— The above query select their managers

select current_date – 16;  — select 16 days less than current date (no time)

select current_date – add_months(now() ,-3)

— The above query selects current datetime –  3 months (with time)