topic Teradata date conversion in SAS Studio

Teradata date conversion

crawfe — Thu, 30 Jan 2020 14:06:56 GMT

Hi. I am new to TD coding. In DI Studio, I would like to convert 08JAN2020 date format to mm/yyyy and

use mm/yyyy for my grouping (ie by month/year only, ignore day of the month). In SAS I used this: INPUT(PUT(date,mmyys7.),anydtdte7.

It looks too exotic but it worked good to just give me month/year.

How would I get to the same date value in teradata? Thanks!

(Is this the correct forum for TD questions?).

Tom — Thu, 30 Jan 2020 14:54:16 GMT

It looks like you just want to move to the first day of the month. So in SAS you would just do:

intnx('month',date,0,'b')

For Teradata questions you should ask on a Teradata forum. But looking around quickly I found this post that seems to do what you want.

DATE - (EXTRACT(DAY FROM DATE)-1)

crawfe — Thu, 30 Jan 2020 18:49:12 GMT

Thanks! I will try to get on that TD forum for my specific questions. I have always gotten helpful information here!

That worked, giving me 1Jan2020, which with the monyy7. format, displays "Jan2020". Perfect. Thanks.