Conversion of Date into Year in Oracle.

[renuka_sasikumar]

Hi,

I would like to extract data from Oracle server where I have to filter data>='2014' & here the Date field is in Date Format.

i.e. DD/MM/YYYY HH:MM:SS

So how do I convert into Year.

I dont want to use Preceding load because it is taking tooo long time.

Anyone can.

Regards,

Renuka S

[PrashantSangle]

hi,

use to_char(date_field,'yyyy')

Regards,

[prma7799]

Please look this

TO_CHAR

TO_CHAR (datetime)

[PrashantSangle]

Hi,

in oracle there is year() too available.

so you can use like that in sql query

where year(datefield)>='2014';

Regards,

[nehasaxena]

Try like this -

Year(date(floor(date_field), 'MM/DD/YYYY'))

Best Regards,

Neha

[Kushal_Chawda]

where to_date(to_char(YourDateField,'YYYY'),'YYYY') >'2014'

[renuka_sasikumar · Accepted solution]

Hi All,

Thanks for the reply. I got the answer for this.

To_number(To_Char("LAST_UPDATE_DATE",'YYYY'),'9999')

Regards,

Renuka S

[matKa]

Why 9999 at the end?