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.
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.
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.