Converting Time stamp in UTC including Day light Saving

General

Converting Time stamp in UTC including Day light Saving

Hi All,

Please can anybody help me out with below query.

We are receving timestamp values from our server which is located in UK right now.We need to convert all the timestamp values in UTC for our reports.

As per my understanding,UK will be in BST during Summers and will be in GMT, the rest of the year.

The UTC and GMT timestamp are same and hence during winters we do not need any conversion but during summer time ,we need to subtract 1 hour from the received timestamp.

Is there a commom function or method to identify the BST period and convert time during that period.

Highly appreciate any help on this.

Thanks!!!

Tags (1)
3 REPLIES
Teradata Employee

Re: Converting Time stamp in UTC including Day light Saving

The query is not attached. In any case, it sounds like Teradata support needs to assist in the timezone rules configuation settings in DBSControl, tdlocaledef and the gettimezonedisplacement UDF.

-Dave

Re: Converting Time stamp in UTC including Day light Saving

We have not yet generated the query since we are not able to convert the UK BST time in UTC?

Junior Contributor

Re: Converting Time stamp in UTC including Day light Saving

You get a timestamp with daylight savings but without the time zone? How do you know the actual time for '2016-10-30 01:30:00'?

You might try SET TIME ZONE  'europe western' for the session.