Timezone conversion

Analytics
Fan

Timezone conversion

My default teradata session timezone is modified as below

set session 'Europe Eastern'

Eastern Europe is +2 hours ahead of UTC and +3 hrs ahead during daylight savings

help session shows it as +2:00
Current UTC Time : 2018-11-04 19:28:00

Current Time is Eastern Europe is 2018-11-04 21:28:00

below query in the database

SELECT CURRENT_TIMESTAMP(0)
2018-11-04 20:28:00+02:00


What does +2 in the above resultset mean?

Tags (1)
4 REPLIES
Junior Contributor

Re: Timezone conversion

What does +2 in the above resultset mean?


That you missed the switch back from DST, which occured Sunday morning October 28th all over Europe :-)

 

Which country do you live in?

Fan

Re: Timezone conversion

@dnoeth- I am based out of Sweden

Fan

Re: Timezone conversion

I believe switch back from DST should have been considered internally by the database.

 

My actual requirement is to get the timestamp in UTC time standard with input being the db current timestamp, irrespecive of the timezone of the session.How can i achieve it?

 

Also , when the output is 2018-11-04 20:28:00+02:00.Does this mean the offset between the UTC time standard and system timestamp is 2 hrs?

Junior Contributor

Re: Timezone conversion


I believe switch back from DST should have been considered internally by the database.


Yes, it was considered.
 

My actual requirement is to get the timestamp in UTC time standard with input being the db current timestamp, irrespecive of the timezone of the session.How can i achieve it

Specify Current_Timestamp(0) AT 0

 


Also , when the output is 2018-11-04 20:28:00+02:00.Does this mean the offset between the UTC time standard and system timestamp is 2 hrs?


Yes, the +02:00 is the current timezone, Eastern Europe Standard Time), two hours ahead UTC.

Will be 2018-11-04 20:28:00+01:00 in Sweden.