Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Extract Year from Date Field Example

Language: Layout:
absolute service time: 1,26 sec 
edit mode |  history  | discussion
   oracle version
1 Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
2 PL/SQL Release 11.2.0.2.0 - Production
3 CORE 11.2.0.2.0 Production
4 TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
5 NLSRTL Version 11.2.0.2.0 - Production
   SYSDATE
1 20.02.2019 19:52:44
   TO_CHAR(SYSDATE,'YYYY')
1 2019