Format "date" data type from database

[Ilya Nikitin]

Hello Egor,

Thank you for your support.

With this line, time is being displayed in following format.

04:11:50.491

How can i remove .491 and leave only hour:minutes:second.

Thank you in advance.

Ilya

[Egor Kotov6832188]

Hello Ilya,

try next
return date_parts[2]+"/"+date_parts[1]+"/"+date_parts[0] + " - " + date[1].split(".")[0];

[Ilya Nikitin]

Hello Egor,

Thanks, thats works perfectly

If someone is looking JS code to format the Date and time dd/mm/yyyy - hh:mm:ss

var date = value.split(" ");
var date1 = date[0];
var date_parts = date1.split("-");
return date_parts[2]+"/"+date_parts[1]+"/"+date_parts[0]+ " - " + date[1].split(".")[0];

BR
Ilya

[Zhivko Zhelev]

HI, I have similar but quite different problem

I want to show the name of the month

I did this

var date = value.split(" ");
var date1 = date[0];
var date_parts = date1.split("-");
var monthNames = ["January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November", "December"
];
return date_parts[2]+" "+monthNames[date_parts[1]]+" "+date_parts[0];

but it gives me for example 04 undefined 2016

Any suggestions?

[Serhii Kulibaba]

Hello Zhivko,

Please use JS below for that:
prevar monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"
];

var d = new Date(value);
return d.getDate() + " " + monthNames[d.getMonth()] + " " + d.getFullYear();/pre