date conversion

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Highlighted
Enthusiast

date conversion

Hi,

 

someone know how to convert  from sql to TERA:

where
convert(int,convert(varchar,getdate(),112)) not between a.FromDate and convert(int,convert(varchar,convert (datetime , CONVERT (datetime,LEFT(a.ToDate,8)) , 101)+ 1 ,112))

 

**ToDate <=  convert(int,convert(varchar,getdate()-1,112))

**FromDate = convert(int,convert(varchar,getdate(),112))

 

Tx!