Timezone Conversion

Hi All, We have an external system where Remedy receives Updateds and create record in WorkLog of a form in Text format. In this text format a datetime information is stored as UTC Zero offset "*2013-06-24T10:10:10" format.* *Now whenever User opens it, view the value instead of local time. * **

UNSUBSCRIBE

Robert Gajic ESMC Remedy Developer Lockheed Martin Australia Level 2, 53 Wentworth Avenue Kingston ACT 2604 Australia P.O. Box 6003 Kingston ACT 2604 Australia E-mail: robert.ga...@lmal.com.au [cid:image001.jpg@01CE70DC.09EE6EE0]

Re: Lost view in Database of T852

I think this is true only for DB2 and older versions of oralce, sqlserver databases. For newer versions of oracle and sqlserver the system uses direct alter table commands. It does not copy the entire table anymore. On Thursday, June 20, 2013 3:47:28 PM UTC-7, Joe D'Souza wrote: > > ** > >