Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
Syntax
SQL> SQL> SQL> SELECT 2 ROUND(SYSDATE, 'MONTH') near_month, 3 SYSDATE today 4 FROM DUAL; NEAR_MONT TODAY --------- --------- 01-JUL-08 20-JUN-08 SQL>