title: Teradata - Invalid time zone specified while converting time zones
body: <p>I am trying to do a join between a date column and the current date in a local timezone using:</p>
  
  <pre><code>SELECT a.* FROM 
  a
  join b on (a.country_id  = b.country_id)
  and date_column =  (Current_date at b.capital_timezone)
  </code></pre>
  
  <p>b.capital_timezone has values like Europe Central, Europe Eastern,GMT+4, GMT+5:30 etc.,</p>
  
  <p>I get an error saying - 'Invalid time zone specified'</p>