Which Date function can be used to extract month(Character) from teradata column value ?

[varunsudham]

Hi all,

Can anyone suggest me how to or which function can be used to extract month from a date value in Teradata.

Ex: November from 25/11/2010(dd/mm/yy) date value.

[Steelers_In_DC]

Here you go:

data have;

infile cards dsd;

informat date_value ddmmyy10.;

format date_value ddmmyy10.;

input date_value;

cards;

25/11/2010

;

run;

data want;

set have;

/*numeric*/

month1 = month(date_value);

/*Character*/

month2 = substr(put(date_value,ddmmyy10.),4,2);

run;