DekGenius.com
Home
(current)
Dictionary
BOOKS
LYRICS
CHORD
SCRIPT & CODE EXAMPLE
Karaoke language
Search
Go
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
COMMENT
Name
5+7 =
Submit