Year conversion in script

[#1]

I have a column with the following date format: YYYYMMDD, and I would like to take the years of this column in the script, but with the function year (column_name) it returns me a number 52620 something like that, I wonder what is the correct method the year to get such a column. Thank you.

[nagaiank]

Yiu may try

Left(column_name,4)

or

Year(Date(Date#(column_name,'YYYYMMDD')))

[MayilVahanan]

Hi,

     Try like this,

     In script:

     Load *,Year(Date(Date#(DateField,'YYYYMMDD'),'YYYY/MM/DD')) as Year from tablename;

     (0r)

     Can you post a sample?

Hope it helps