Timezone issue with Javascript (156 Views)
Reply
Valued Contributor
alscpe
Posts: 82
Registered: ‎09-02-2008
Message 1 of 1 (156 Views)

Timezone issue with Javascript

i have now struggling with a TimeZone issue for also 24h and i need some more braintrust here.

 
I receive a date/time stamp (in a text field), through a web-service, there is storing all the information in at temp table. A trigger on the temp table is creating a incident with the information there is received. The date / time stamp are in UTC time and look like this <CustomerSpecific4>09/26/2013 14:09:28</CustomerSpecific4>

 
The user there is logging into the web-service has "Greenwich/Universal" as timezone and the date format "mm/dd/yyyy".

 
After the trigger has run are the date/time stamp in the DB now "2013-09-26 12:09:28.000" and that is total unexpected. because it's 2h offset from the expected timestamp.

 
The code the is inserting the date into incident is this

var insertdate = record.CustomerField4;
newIncident.AKZIncidentCreationDate =new Date(record.CustomerField4);

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation