Skip to main content
1-Visitor
December 19, 2018
Solved

Javascript service

  • December 19, 2018
  • 1 reply
  • 5001 views

Does anyone know how to convert timestamp to Datetime in Javascript please? thank you so much? 

This is my service that returns dates but in MS i need to bind its output to an SQL query who uses datetime as inputs : 

var currentDate=new Date(Date.now());
var currentWeekDay=currentDate.getDay();
var currentHour=currentDate.getHours();
var currentMonthDay=currentDate.getDate();
var currentMonth=currentDate.getMonth();
var currentYear=currentDate.getFullYear();
var SelectedButton ;
var myStartDate;
var myEndDate ;
var i=currentWeekDay;
var j=currentMonthDay;
var newEntry=new Object ();
if (SelectedButton=="Yesterday"){
myStartDate=currentDate;
myStartDate.setDate((currentDate.getDate())-1);
myStartDate.setHours(06);
myEndDate=new Date(Date.now());
myEndDate.setHours(06);

}
if (SelectedButton=="Week To Date"){
myStartDate = currentDate;
myStartDate.setHours(06);
if(j<i) { myStartDay.setDate(30-(7-i+j));
myStartMonth.setMonth=currentMonth-1;
myStartDate.setHours(06);} else {
myStartDate=currentDate;
myStartDate.setDate(j+1-i);
myStartDate.setHours(06);
}
myEndDate=new Date(Date.now());
myEndDate.setHours(06);
}


newEntry.StartDate= myStartDate;
newEntry.EndDate = myEndDate;

var params = {
infoTableName : "InfoTable",
dataShapeName : "StartEndDate"
};
var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

result.AddRow(newEntry);

 

Best answer by CarlesColl

If you want to export Javascript Date objects to Unix timestamp you can do yourDateObject.getTime().

 

If you want to format Javascript Date objects to a String based DateTime you can use dateFormat(yourDateObject,"desired_date_format") or dateFormatISO(yourDateObject)

 

Thouse are the options on server side to convert Dates to different "object formats".

 

But always remember that at server side, when you use dateFormat it will be on Server TimeZone.

1 reply

1-Visitor
December 19, 2018

If you want to export Javascript Date objects to Unix timestamp you can do yourDateObject.getTime().

 

If you want to format Javascript Date objects to a String based DateTime you can use dateFormat(yourDateObject,"desired_date_format") or dateFormatISO(yourDateObject)

 

Thouse are the options on server side to convert Dates to different "object formats".

 

But always remember that at server side, when you use dateFormat it will be on Server TimeZone.

i_abidi1-VisitorAuthor
1-Visitor
December 19, 2018

you got a point now that i read it again 😛 , i'll explain : the javascript i wrote is supposed to generate a start and an end time based ona  string input. i want to use my output to input an SQL Query that uses DATETIME parameters .

When i run my JAVASCRIPT on test mode it generates results in ms as my datashape of my result info table has string parameters, but when i change the datashape to something with datetime parameters it generates nothing.