[email protected]:~$ echo $TZAmerica/New_York
CURRENT_TIMESTAMP = 2014-12-17 18:58:27 EST
[email protected]:~$ date --date='TZ="UTC" 2014-12-17 18:58:27 EST'Wed Dec 17 13:58:27 EST 2014
[email protected]:~$ date --date='TZ="UTC" 2014-12-17 13:58:27 EST'Wed Dec 17 08:58:27 EST 201
When I do -- show timezone it gives me UTC
But when I do select CURRENT_TIMESTAMP it gives me 2014-12-18 11:12:28 which is the current time in EST .
When I ran this this was time in New York
my understanding is that it should have returned me the current time in UTC
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.