Page 2 of 2

Format "date" data type from database

Posted: Sun Mar 22, 2015 11:10 pm
by 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


Format "date" data type from database

Posted: Tue Mar 24, 2015 6:34 pm
by Egor Kotov6832188

Hello Ilya,

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


Format "date" data type from database

Posted: Tue Mar 24, 2015 6:46 pm
by 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


Format "date" data type from database

Posted: Thu Jun 16, 2016 9:06 am
by 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?


Format "date" data type from database

Posted: Thu Jun 16, 2016 6:00 pm
by 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