Epoc Date conversion

[monu1]

Hello Everyone,

In our project , ticket is created through Integration with Remedy.

So they are sending Planned Start And End Date of Change in EPOC format.

I have converted in Servicenow in yyyy/mm/dd HH:mm:ss format. But the time is not working Perfectly

Code:

var timestamp = 1536914778;

var dt = new Date(timestamp*1000);
var year = dt.getFullYear();
var month = dt.getMonth() + 1;
var day = dt.getDate();
var hours = dt.getHours();
var minutes = dt.getMinutes();
var seconds = dt.getSeconds();

document.write(year+"-"+month+"-"+day+" " +hours+":"+minutes+":"+seconds);

Output: 

2018-9-14 1:46:18(servicenow)
2018-9-14 14:16:18(javascript console)

It should come as Javascript console but in servicenow the timeing is coming as 1 instead of 14.

Could anyone tell me why the time is not working correctly in Servicenow.

[johnnyd54]

If epoc is date/time in milliseconds, you could do something like this:

ar gdt = new GlideDateTime();
gdt.setNumericValue(1536914778000);
gs.print(gdt);

2018-09-14 08:46:18

[monu1]

It is not 

08:46:18 , the actual time is 14:16:18

[johnnyd54]

Yeah the 8:46 is the time in UTC time. What time zone are you? Depending on where you are, the local time will be different.

[monu1]

Could you please help me to convert Todays date in epoch format.