The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Could you point how to format a date from YYYY/MM/DD HH:MM:SS to DD/MM/YYYY HH:MM:SS by using jQuery?
Hi Experts
Could you point how to format a date from YYYY/MM/DD HH:MM:SS to DD/MM/YYYY HH:MM:SS by using jQuery?
Thanks in advance.
Could you point how to format a date from YYYY/MM/DD HH:MM:SS to DD/MM/YYYY HH:MM:SS by using jQuery?
Thanks in advance.
Asked:
-
4
3
2
2 Solutions
Eduardo, please, please, please take a moment to learn the right way of handling date/time values. This is not "new" or something that needs to be reinvented. We have the ISO-8601 standard for date/time representations. All internal computer programming date/time representations should be ISO-8601. You only change the format for external display, full stop. It's really, really, really worth doing it the right way because any other way leads to endless troubles, sadness, confusion, tears, and anguish. Even little things, like the difference between slashes and dashes, can matter a lot, but there are safe, predictable ways to handle these values. I promise that the "good ways" are your friend!
Here's the ten-year old procedural way:
https://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL-Procedural-Version.html
Here's the modern object-oriented way:
https://www.experts-exchange.com/articles/20920/Handling-Time-and-Date-in-PHP-and-MySQL-OOP-Version.html
Here's the ten-year old procedural way:
https://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL-Procedural-Version.html
Here's the modern object-oriented way:
https://www.experts-exchange.com/articles/20920/Handling-Time-and-Date-in-PHP-and-MySQL-OOP-Version.html
@Ray
Thank you for your concerns.
I guess this case is a matter of jQuery date convertion. I don't see how to capture the textbox value by PHP code.
Thank you for your concerns.
I guess this case is a matter of jQuery date convertion. I don't see how to capture the textbox value by PHP code.
In the meanwhile I found a javascript function for date format convertion:
It runs OK.
<script type="text/javascript">
function formatDate(dateVal) {
var newDate = new Date(dateVal);
var sMonth = padValue(newDate.getMonth() + 1);
var sDay = padValue(newDate.getDate());
var sYear = newDate.getFullYear();
var sHour = newDate.getHours();
var sMinute = padValue(newDate.getMinutes());
var sSeconds = newDate.getSeconds();
if (sSeconds=="0") {
sSeconds = "00";
}
var iHourCheck = parseInt(sHour);
return sDay + "-" + sMonth + "-" + sYear + " " + sHour + ":" + sMinute + ":" + sSeconds;
}
function padValue(value) {
return (value < 10) ? "0" + value : value;
}
</script>
It runs OK.
Sorry, I misunderstood this to be a PHP question because it was in the PHP topic area. The JS Date() method looks like the right solution.
return sDay + "-" + sMonth + "-" + sYear + " " + sHour + ":" + sMinute + ":" + sSeconds;
NOT
DD/MM/YY HH:MM:SS
return sDay + "/" + sMonth + "/" + sYear + " " + sHour + ":" + sMinute + ":" + sSeconds;
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Open in new window
But if you do you will get this warning noticeBottom line you need to look at why you need those formats and potentially change them.