Then in a transformer I convert it to VarChar(50) using the following
Code: Select all
Oconv(lnk_inp.D_DATA_STORE_DATE,'MTS')
But the value in a file is 04:26:42, rather than 17:08:25.
Am I using the wrong time format? Is there some timezone indicator I should use (however I cannot find much information about time zones in DS)?