Function to Convert Between Timezones

[usli06]

Is there a function in Vertica we can use to convert between time zones? Preferably something like the MySQL CONVERT_TZ function:

Code: Select all

mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');
        -> '2004-01-01 13:00:00'
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','+10:00');
        -> '2004-01-01 22:00:00'

Thanks

[id10t]

Hi!

• Code: Select all

  daniel=> SELECT TIMESTAMP WITH TIME ZONE '2004-01-01 12:00:00 GMT' AT TIME ZONE 'MET';
        timezone       
  ---------------------
   2004-01-01 13:00:00
  (1 row)
  

• Code: Select all

  daniel=> SELECT TIMESTAMP '2004-01-01 12:00:00' AT TIME ZONE 'MET';
          timezone        
  ------------------------
   2004-01-01 13:00:00+02
  (1 row)
  

• Code: Select all

  daniel=> SELECT TIMESTAMP WITH TIME ZONE '2004-01-01 12:00:00+00' AT TIME ZONE 'MET';
        timezone       
  ---------------------
   2004-01-01 13:00:00
  (1 row)
  

• Code: Select all

  daniel=> SELECT NEW_TIME('2004-01-01 12:00:00', 'gmt', 'met');
        NEW_TIME       
  ---------------------
   2004-01-01 13:00:00
  (1 row)
  

[usli06]

Thanks for the super fast response! Perfect solution!