Converting Time Zones in SAP BODS

In SAP Data Services 4.2 SP 03, there are two functions called local_to_utc and utc_to_local .
We can use local_to_utc to convert current time zone to desired timezone .

Previous version custom functions.

local_to_utc(‘2014.02.01 00:00:00’, ‘UTC+08:30’) = ‘2014.01.31 15:30:00’

utc_to_local(‘2014.01.31 15:30:00’, ‘UTC+08:30’) = ‘2014.02.01 00:00:00’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: