I need to convert GMT date/time format into IST format.

niveditakumari · ‎10-29-2019

Hello,

I am getting value of date/time field in GMT format from one API and inserting that value to my table. I need to convert that GMT format into IST then I want to insert that value in my table.

Can anyone please help me with this.

Regards,

Nivedita

asifnoor · ‎10-31-2019

Hi, It's bcoz your system timezone is ist. So while storing it is converting to ist. If you don't want that conversion then in our earlier code, Just change this line and uncomment the other lines. Packages.java.util.TimeZone.getTimeZone("IST"); //sets to IST TO Packages.java.util.TimeZone.getTimeZone("GMT"); //sets to GMT and check.

View solution in original post

niveditakumari · ‎10-30-2019

Hello Asifnoor,

I am not getting the correct date/time.

Below is my code :

try {
var r = new sn_ws.RESTMessageV2('Get PlannedEvents Data - sandbox', 'GET');

//override authentication profile
authentication_type ='basic';
r.setAuthenticationProfile(authentication_type, '3394f9fe1b8ccc9077694005bd4bcbe1');

var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();

//gs.print(responseBody);
gs.log("response body is" + responseBody);
var obj = JSON.parse(responseBody);

var gdt = new GlideDateTime();
var tz = Packages.java.util.TimeZone.getTimeZone("IST"); //sets to IST
gdt.setTZ(tz);

for(var i = 0; i<obj.plannedEvents.length; i++) {

var gr = new GlideRecord('u_tcl_plannedevents');
gr.addQuery('u_ticket_id', obj.plannedEvents[i].ticketId);
gr.query();
if (!gr.next()) {
gs.log("insert records");
gr.initialize();

var Event_start_date = obj.plannedEvents[i].plannedEventStartDate;
var Event_end_date = obj.plannedEvents[i].plannedEventEndDate;
gdt.setValue(new GlideDateTime(Event_start_date));
gdt.setValue(new GlideDateTime(Event_end_date));
gr.u_plannedevent_start_date =gdt.getDisplayValue();
gr.u_plannedevent_end_date =gdt.getDisplayValue();

gr.u_rollback_plan = obj.plannedEvents[i].rollbackPlan;
//gr.u_plannedevent_start_date = obj.plannedEvents[i].plannedEventStartDate;
gr.u_closure_code = obj.plannedEvents[i].closureCode;
gr.u_description = obj.plannedEvents[i].description;

//gr.u_plannedevent_end_date = obj.plannedEvents[i].plannedEventEndDate;
gr.u_ticket_id = obj.plannedEvents[i].ticketId;
gr.u_correlation_id = obj.plannedEvents[i].correlationId;
gr.u_impact = obj.plannedEvents[i].impact;
gr.u_execution_owner = obj.plannedEvents[i].executionOwner;
gr.u_maintenance_type = obj.plannedEvents[i].maintenanceType;
gr.u_site_location= obj.plannedEvents[i].siteLocation;
gr.u_expected_downtime= obj.plannedEvents[i].expectedDowntime;
gr.u_activity_status= obj.plannedEvents[i].activityStatus;

//for(var j = 0; j<obj.plannedEvents[i].services.length; j++) {

gr.u_service_identifier1 = obj.plannedEvents[i].services[0].serviceIdentifier;
gr.u_protection_status1 = obj.plannedEvents[i].services[0].protectionStatus;
gr.u_service_type1 = obj.plannedEvents[i].services[0].serviceType;
gr.u_service_alias1 = obj.plannedEvents[i].services[0].serviceAlias;
gr.u_customer_le_name1 = obj.plannedEvents[i].services[0].customerLeName;
gr.u_cuid1 = obj.plannedEvents[i].services[0].cuid;

gr.u_service_identifier2 = obj.plannedEvents[i].services[1].serviceIdentifier;
gr.u_protection_status2 = obj.plannedEvents[i].services[1].protectionStatus;
gr.u_service_type2 = obj.plannedEvents[i].services[1].serviceType;
gr.u_service_alias2 = obj.plannedEvents[i].services[1].serviceAlias;
gr.u_customer_le_name2 = obj.plannedEvents[i].services[1].customerLeName;
gr.u_cuid2 = obj.plannedEvents[i].services[1].cuid;

gr.u_service_identifier3 = obj.plannedEvents[i].services[2].serviceIdentifier;
gr.u_protection_status3 = obj.plannedEvents[i].services[2].protectionStatus;
gr.u_service_type3 = obj.plannedEvents[i].services[2].serviceType;
gr.u_service_alias3 = obj.plannedEvents[i].services[2].serviceAlias;
gr.u_customer_le_name3 = obj.plannedEvents[i].services[2].customerLeName;
gr.u_cuid3 = obj.plannedEvents[i].services[2].cuid;

gr.u_service_identifier4 = obj.plannedEvents[i].services[3].serviceIdentifier;
gr.u_protection_status4 = obj.plannedEvents[i].services[3].protectionStatus;
gr.u_service_type4 = obj.plannedEvents[i].services[3].serviceType;
gr.u_service_alias4 = obj.plannedEvents[i].services[3].serviceAlias;
gr.u_customer_le_name4 = obj.plannedEvents[i].services[3].customerLeName;
gr.u_cuid4 = obj.plannedEvents[i].services[3].cuid;

gr.insert();
//gs.log("table data is" + responseBody);

} else {
// update the record
gs.log("update records");
//var gdt = new GlideDateTime();
//var tz = Packages.java.util.TimeZone.getTimeZone("IST"); //sets to IST
//gdt.setTZ(tz);
var Event_start_date_1 = obj.plannedEvents[i].plannedEventStartDate;
var Event_end_date_1 = obj.plannedEvents[i].plannedEventEndDate;
gdt.setValue(new GlideDateTime(Event_start_date_1));
gdt.setValue(new GlideDateTime(Event_end_date_1));
gr.u_plannedevent_start_date =gdt.getDisplayValue();
gr.u_plannedevent_end_date =gdt.getDisplayValue();

gr.u_rollback_plan = obj.plannedEvents[i].rollbackPlan;
//gr.u_plannedevent_start_date = obj.plannedEvents[i].plannedEventStartDate;
gr.u_closure_code = obj.plannedEvents[i].closureCode;
gr.u_description = obj.plannedEvents[i].description;
//gr.u_plannedevent_end_date = obj.plannedEvents[i].plannedEventEndDate;
gr.u_ticket_id = obj.plannedEvents[i].ticketId;
gr.u_correlation_id = obj.plannedEvents[i].correlationId;
gr.u_impact = obj.plannedEvents[i].impact;
gr.u_execution_owner = obj.plannedEvents[i].executionOwner;
gr.u_maintenance_type = obj.plannedEvents[i].maintenanceType;
gr.u_site_location= obj.plannedEvents[i].siteLocation;
gr.u_expected_downtime= obj.plannedEvents[i].expectedDowntime;
gr.u_activity_status= obj.plannedEvents[i].activityStatus;

//for(var j = 0; j<obj.plannedEvents[i].services.length; j++) {

gr.u_service_identifier1 = obj.plannedEvents[i].services[0].serviceIdentifier;
gr.u_protection_status1 = obj.plannedEvents[i].services[0].protectionStatus;
gr.u_service_type1 = obj.plannedEvents[i].services[0].serviceType;
gr.u_service_alias1 = obj.plannedEvents[i].services[0].serviceAlias;
gr.u_customer_le_name1 = obj.plannedEvents[i].services[0].customerLeName;
gr.u_cuid1 = obj.plannedEvents[i].services[0].cuid;

gr.u_service_identifier2 = obj.plannedEvents[i].services[1].serviceIdentifier;
gr.u_protection_status2 = obj.plannedEvents[i].services[1].protectionStatus;
gr.u_service_type2 = obj.plannedEvents[i].services[1].serviceType;
gr.u_service_alias2 = obj.plannedEvents[i].services[1].serviceAlias;
gr.u_customer_le_name2 = obj.plannedEvents[i].services[1].customerLeName;
gr.u_cuid2 = obj.plannedEvents[i].services[1].cuid;

gr.u_service_identifier3 = obj.plannedEvents[i].services[2].serviceIdentifier;
gr.u_protection_status3 = obj.plannedEvents[i].services[2].protectionStatus;
gr.u_service_type3 = obj.plannedEvents[i].services[2].serviceType;
gr.u_service_alias3 = obj.plannedEvents[i].services[2].serviceAlias;
gr.u_customer_le_name3 = obj.plannedEvents[i].services[2].customerLeName;
gr.u_cuid3 = obj.plannedEvents[i].services[2].cuid;

gr.u_service_identifier4 = obj.plannedEvents[i].services[3].serviceIdentifier;
gr.u_protection_status4 = obj.plannedEvents[i].services[3].protectionStatus;
gr.u_service_type4 = obj.plannedEvents[i].services[3].serviceType;
gr.u_service_alias4 = obj.plannedEvents[i].services[3].serviceAlias;
gr.u_customer_le_name4 = obj.plannedEvents[i].services[3].customerLeName;
gr.u_cuid4 = obj.plannedEvents[i].services[3].cuid;

gr.update();
}
gs.log("##plannedevents is##" + obj.plannedEvents.length);
gs.log("##Service is##"+obj.plannedEvents[i].services.length);
}
} catch (ex) {
var message = ex.message;
}

//gs.print("##planned Description##"+obj.plannedEvents.length);
//gs.print("##Service###"+obj.plannedEvents[0].services.length);
//var service_length = obj.plannedEvents[0].services.length;

//gs.print("##Service is###"+service_length);

Please correct me if i am wrong.

Regards,

Nivedita

asifnoor · ‎10-30-2019

Try this and let me know the log output.

try {
var r = new sn_ws.RESTMessageV2('Get PlannedEvents Data - sandbox', 'GET');

//override authentication profile
authentication_type ='basic';
r.setAuthenticationProfile(authentication_type, '3394f9fe1b8ccc9077694005bd4bcbe1');

var response = r.execute();
var responseBody = response.getBody();
var httpStatus = response.getStatusCode();

//gs.print(responseBody);
gs.log("response body is" + responseBody);
var obj = JSON.parse(responseBody);

var gdt = new GlideDateTime();
var tz = Packages.java.util.TimeZone.getTimeZone("IST"); //sets to IST
gdt.setTZ(tz);

for(var i = 0; i<obj.plannedEvents.length; i++) {

var gr = new GlideRecord('u_tcl_plannedevents');
gr.addQuery('u_ticket_id', obj.plannedEvents[i].ticketId);
gr.query();
if (!gr.next()) {
gs.log("insert records");
gr.initialize();

var Event_start_date = obj.plannedEvents[i].plannedEventStartDate;
var Event_end_date = obj.plannedEvents[i].plannedEventEndDate;
gs.log("Start and end dates are "+Event_start_date+"---"+Event_end_date);
gdt.setValue(new GlideDateTime(Event_start_date));
gr.u_plannedevent_start_date =gdt.getDisplayValue();
gdt.setValue(new GlideDateTime(Event_end_date));
gr.u_plannedevent_end_date =gdt.getDisplayValue();

gr.u_rollback_plan = obj.plannedEvents[i].rollbackPlan;
//gr.u_plannedevent_start_date = obj.plannedEvents[i].plannedEventStartDate;
gr.u_closure_code = obj.plannedEvents[i].closureCode;
gr.u_description = obj.plannedEvents[i].description;

//gr.u_plannedevent_end_date = obj.plannedEvents[i].plannedEventEndDate;
gr.u_ticket_id = obj.plannedEvents[i].ticketId;
gr.u_correlation_id = obj.plannedEvents[i].correlationId;
gr.u_impact = obj.plannedEvents[i].impact;
gr.u_execution_owner = obj.plannedEvents[i].executionOwner;
gr.u_maintenance_type = obj.plannedEvents[i].maintenanceType;
gr.u_site_location= obj.plannedEvents[i].siteLocation;
gr.u_expected_downtime= obj.plannedEvents[i].expectedDowntime;
gr.u_activity_status= obj.plannedEvents[i].activityStatus;

//for(var j = 0; j<obj.plannedEvents[i].services.length; j++) {

gr.u_service_identifier1 = obj.plannedEvents[i].services[0].serviceIdentifier;
gr.u_protection_status1 = obj.plannedEvents[i].services[0].protectionStatus;
gr.u_service_type1 = obj.plannedEvents[i].services[0].serviceType;
gr.u_service_alias1 = obj.plannedEvents[i].services[0].serviceAlias;
gr.u_customer_le_name1 = obj.plannedEvents[i].services[0].customerLeName;
gr.u_cuid1 = obj.plannedEvents[i].services[0].cuid;

gr.u_service_identifier2 = obj.plannedEvents[i].services[1].serviceIdentifier;
gr.u_protection_status2 = obj.plannedEvents[i].services[1].protectionStatus;
gr.u_service_type2 = obj.plannedEvents[i].services[1].serviceType;
gr.u_service_alias2 = obj.plannedEvents[i].services[1].serviceAlias;
gr.u_customer_le_name2 = obj.plannedEvents[i].services[1].customerLeName;
gr.u_cuid2 = obj.plannedEvents[i].services[1].cuid;

gr.u_service_identifier3 = obj.plannedEvents[i].services[2].serviceIdentifier;
gr.u_protection_status3 = obj.plannedEvents[i].services[2].protectionStatus;
gr.u_service_type3 = obj.plannedEvents[i].services[2].serviceType;
gr.u_service_alias3 = obj.plannedEvents[i].services[2].serviceAlias;
gr.u_customer_le_name3 = obj.plannedEvents[i].services[2].customerLeName;
gr.u_cuid3 = obj.plannedEvents[i].services[2].cuid;

gr.u_service_identifier4 = obj.plannedEvents[i].services[3].serviceIdentifier;
gr.u_protection_status4 = obj.plannedEvents[i].services[3].protectionStatus;
gr.u_service_type4 = obj.plannedEvents[i].services[3].serviceType;
gr.u_service_alias4 = obj.plannedEvents[i].services[3].serviceAlias;
gr.u_customer_le_name4 = obj.plannedEvents[i].services[3].customerLeName;
gr.u_cuid4 = obj.plannedEvents[i].services[3].cuid;

gr.insert();
//gs.log("table data is" + responseBody);

} else {
// update the record
gs.log("update records");
//var gdt = new GlideDateTime();
//var tz = Packages.java.util.TimeZone.getTimeZone("IST"); //sets to IST
//gdt.setTZ(tz);
var Event_start_date_1 = obj.plannedEvents[i].plannedEventStartDate;
var Event_end_date_1 = obj.plannedEvents[i].plannedEventEndDate;
gdt.setValue(new GlideDateTime(Event_start_date_1));
gdt.setValue(new GlideDateTime(Event_end_date_1));
gr.u_plannedevent_start_date =gdt.getDisplayValue();
gr.u_plannedevent_end_date =gdt.getDisplayValue();

gr.u_rollback_plan = obj.plannedEvents[i].rollbackPlan;
//gr.u_plannedevent_start_date = obj.plannedEvents[i].plannedEventStartDate;
gr.u_closure_code = obj.plannedEvents[i].closureCode;
gr.u_description = obj.plannedEvents[i].description;
//gr.u_plannedevent_end_date = obj.plannedEvents[i].plannedEventEndDate;
gr.u_ticket_id = obj.plannedEvents[i].ticketId;
gr.u_correlation_id = obj.plannedEvents[i].correlationId;
gr.u_impact = obj.plannedEvents[i].impact;
gr.u_execution_owner = obj.plannedEvents[i].executionOwner;
gr.u_maintenance_type = obj.plannedEvents[i].maintenanceType;
gr.u_site_location= obj.plannedEvents[i].siteLocation;
gr.u_expected_downtime= obj.plannedEvents[i].expectedDowntime;
gr.u_activity_status= obj.plannedEvents[i].activityStatus;


//for(var j = 0; j<obj.plannedEvents[i].services.length; j++) {

gr.u_service_identifier1 = obj.plannedEvents[i].services[0].serviceIdentifier;
gr.u_protection_status1 = obj.plannedEvents[i].services[0].protectionStatus;
gr.u_service_type1 = obj.plannedEvents[i].services[0].serviceType;
gr.u_service_alias1 = obj.plannedEvents[i].services[0].serviceAlias;
gr.u_customer_le_name1 = obj.plannedEvents[i].services[0].customerLeName;
gr.u_cuid1 = obj.plannedEvents[i].services[0].cuid;

gr.u_service_identifier2 = obj.plannedEvents[i].services[1].serviceIdentifier;
gr.u_protection_status2 = obj.plannedEvents[i].services[1].protectionStatus;
gr.u_service_type2 = obj.plannedEvents[i].services[1].serviceType;
gr.u_service_alias2 = obj.plannedEvents[i].services[1].serviceAlias;
gr.u_customer_le_name2 = obj.plannedEvents[i].services[1].customerLeName;
gr.u_cuid2 = obj.plannedEvents[i].services[1].cuid;

gr.u_service_identifier3 = obj.plannedEvents[i].services[2].serviceIdentifier;
gr.u_protection_status3 = obj.plannedEvents[i].services[2].protectionStatus;
gr.u_service_type3 = obj.plannedEvents[i].services[2].serviceType;
gr.u_service_alias3 = obj.plannedEvents[i].services[2].serviceAlias;
gr.u_customer_le_name3 = obj.plannedEvents[i].services[2].customerLeName;
gr.u_cuid3 = obj.plannedEvents[i].services[2].cuid;

gr.u_service_identifier4 = obj.plannedEvents[i].services[3].serviceIdentifier;
gr.u_protection_status4 = obj.plannedEvents[i].services[3].protectionStatus;
gr.u_service_type4 = obj.plannedEvents[i].services[3].serviceType;
gr.u_service_alias4 = obj.plannedEvents[i].services[3].serviceAlias;
gr.u_customer_le_name4 = obj.plannedEvents[i].services[3].customerLeName;
gr.u_cuid4 = obj.plannedEvents[i].services[3].cuid;

gr.update();
}
gs.log("##plannedevents is##" + obj.plannedEvents.length);
gs.log("##Service is##"+obj.plannedEvents[i].services.length);
}
} catch (ex) {
var message = ex.message;
}

asifnoor · ‎10-30-2019

Please note that i have placed logs and conversion only for insert. Check if your control is going to update instead of insert. If yes, then you need to place same code in the else block as well.

niveditakumari · ‎10-30-2019

Hello Asifnoor,

Can you please help me with this.

Regards,

Nivedita

niveditakumari · ‎10-30-2019

Hello Asifnoor,

In API date/time is different and in table records i am getting different date/time.

I should get below date/time inserted in my table but i am getting different value.

In table i am getting below values :

Can you please correct me where i am doing wrong.

Regards,

Nivedita