Time Zone Conversion In teradata

Database

Time Zone Conversion In teradata

Hi Team,

Can any one help me to convert the time zone in Teradata

i have a data in MYT time zone (Malaysia Time) where i need to run the query in CST Zone (Central Time (CT))

My servere is in CST and i need to pick the  data by MST 3:00am every day.

Can any one helpmw with the Query for converting betwwen this zone.

Thanks

Deepu