Conversion from Oracle to Teradata

General
New Member

Conversion from Oracle to Teradata

Hi!

I'm trying to convert some sentences from Oracle to Teradata. I'm very new on this, so I don't really understand.

 

SELECT

lpad(datep,8,0) date_p,

lpad(datem,8,0) date_m,

to_date (to_char (date_m,'00000009'),'yyyymmdd') - to_date (to_char (datep,'0000009'),'yyyymmdd') days

FROM

table1

WHERE

to_number(substr(to_char(date_p),5,2))>=1

 

How is this in Teradata?

 

Help please :D

 

Thanks!!!