Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

how to get previous year from sysdate in oracle

SELECT extract(YEAR FROM sysdate) - 1 AS PREVIOUS_YEAR FROM DUAL;
 
PREVIOUS NEXT
Tagged: #previous #year #sysdate #oracle
ADD COMMENT
Topic
Name
1+8 =