Extract Year from Date Field Example, Oracle

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

λ

                                      .NET NoSQL database for rapid development