topic Which Date function can be used to extract month(Character) from teradata column value ? in SAS Enterprise Guide

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

varunsudham — Wed, 03 Jun 2015 00:56:46 GMT

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 — Wed, 03 Jun 2015 11:32:56 GMT

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;