How servicenow store the date and time at db level

[pratapdalai]

HI All,

Please let me know how ServiceNow store the value at database level and also please let me know about the what is this date format.

20230926T050000Z 

[Peter Bodelier]

Is this data coming from an import or something?

I would personally just create 2 datetime fields on the table, and transform the iso datetime strings to the datetime fields. This way you can use the data in any way you like.

[Christopher Wea]

This critical piece of information isn't at all clear in the documentation - how to get a GlideDateTime object from a GlideRecordField..

gdt = current.date_field.getGlideObject();

[Dr Atul G- LNG]

Hi @pratapdalai 

May i know what is use case for this , because SN provide the user specific date format easy to understand and use. 

[Ankur Bawiskar]

@pratapdalai 

we will never know how ServiceNow stores it. It's a java based application and the code behind it is hidden from us and not accessible to even admins/developers.