All Forums Database
srikanth471 3 posts Joined 01/12
10 Aug 2016
TimeZone conversion

Hi All,
 
I have a scenario here as below
 
TAB1 has 100Bn rows with timestamp(RPTG_TS) in 'America Pacific' and need to convert this timestamp column to GMT timestamp.
For now i have timezone shift table( Src_TZ,Tgt_TZ,from_dt,to_dt,shift), TAB1 left join Timezone on (rptg_ts between from_dt and to_dt and Src_Tz='America Pacific'
and Tgt_TZ='GMT'). But this is a inequality join, is there a best way to do this.
 
Thanks,
Srikanth

You must sign in to leave a comment.