How to convert the field sys_created_on to UNIX time.

[Alon Grod]

Hi,

I created PUT rest message and I need to pass some parameters to the json. one of the parameters is the field sys_created_on of tyep Date/Time on the incident table.
When Im trying to test the REST Message Im getting error saying:
"Expected unix time" regarding the value of sys_created_on that im passing.
How can I convert this field's value to UNIX time?

[Pratiksha2]

Hello @Alon Grod ,

To convert a Date/Time field to UNIX time ( Epoch time) using the GlideDateTime class you can refer below code:

 var incident = new GlideRecord('incident');
incident.get('sys_id', '//incident_sys_id');
var unixTime = new GlideDateTime(incident.getValue('sys_created_on')).getNumericValue();

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks,

Pratiksha

[Samiksha Gunjat]

Hi @Alon Grod ,

In ServiceNow, you can convert a date/time field value to UNIX time using a GlideDateTime object. You can use its getNumericValue() method to convert a date/time value to UNIX time.

// Get the incident record
var incident = new GlideRecord('incident');
incident.get('sys_id', '<incident_sys_id>'); // Replace <incident_sys_id> with the actual sys_id of the incident

// Get the sys_created_on value
var sysCreatedOn = incident.getValue('sys_created_on');

// Convert sys_created_on to UNIX time
var dateTime = new GlideDateTime(sysCreatedOn);
var unixTime = dateTime.getNumericValue();

gs.info('UNIX Time: ' + unixTime);

Please mark this comment as Correct Answer/Helpful if it helped you. 

Regards,

Samiksha Gunjate