How to change MySQL date format using front end jQuery

Question

MySQL database has date field which contents date format as 2016-02-28 02:11:24. Following php code and j-query displays date on bootstrap model. I want to change the date format as 28 Feb 2016, 02:11 PM How to do it using front end J-query or back end MySQL field format?

<?php
    foreach ($value as $value2) {
        echo "<div class='well'>";
        echo '<p class="target" userRegdate = "' . $value2->added_date . '"  >' . $value2->content . '</p>';
        echo "</div>";
    }
?>

J-query dialog box to display date

//Display dialog box when mouse click
$(".target").click(function () {

    var publish_date = $(this).attr("userRegdate");
    BootstrapDialog.show({
        title: 'user added date',
        message: publish_date            
    });
});

You could use the momentjs library: momentjs.com/docs

cl3m
– cl3m

2016-03-02 16:39:18 +00:00
Commented Mar 2, 2016 at 16:39 — cl3m
– cl3m, Commented Mar 2, 2016 at 16:39

Santosh Ram Kunjir · Accepted Answer · 2016-04-15 04:55:07Z

1

//code added the date function with parameter to format date
<?php
    foreach ($value as $value2) {
        echo "<div class='well'>";
        echo '<p class="target" userRegdate = "' . date("j, F, Y, g:i a",strtotime($value2->added_date)) . '"  >' . $value2->content . '</p>';
        echo "</div>";
    }
?>

edited Apr 15, 2016 at 4:55

answered Mar 2, 2016 at 16:53

Santosh Ram Kunjir

1,0821 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ssube Over a year ago

This code-only answer doesn't explain what was wrong or how to fix it.

Drudge Rajen · Accepted Answer · 2016-03-02 16:43:44Z

1

If you want to use it using PHP then :

<?php
 $yrdata= strtotime('2016-02-28 02:11:24');
    echo date('d M,Y H:i A', $yrdata);
 ?>

OUTPUT

28 Feb,2016 02:11 AM

Using jquery :

You can use jQuery dateFormat plugin .

answered Mar 2, 2016 at 16:43

Drudge Rajen

8,0414 gold badges25 silver badges43 bronze badges

Comments

baao · Accepted Answer · 2016-03-02 16:45:26Z

1

As you're saying you get the data from the database, you could simply format it from there so you don't need to do something on the front-end (or with php) at all. You can use MySQL's DATE_FORMAT() function:

SELECT DATE_FORMAT('2016-02-28 02:11:24', '%e %b %Y, %r')

in a query like

SELECT DATE_FORMAT(dateColumn, '%e %b %Y, %r') formatedDate, colA, colB 
FROM table

answered Mar 2, 2016 at 16:45

baao

73.5k18 gold badges152 silver badges208 bronze badges

Comments

Maxime Savard · Accepted Answer · 2016-03-02 16:46:08Z

1

With moment.js

var date = new Date(*added date*);
var formattedDate = moment(date).format('dd MMM YYYY, h:mm');

where added date is 2016-02-28 02:11:24

answered Mar 2, 2016 at 16:46

Maxime Savard

12812 bronze badges

Comments

Oscar LT · Accepted Answer · 2016-03-02 16:47:24Z

0

Other form is this if you want change the sort easy:

var newDate = date.getDate() + '/' + (date.getMonth() + 1) + '/' +  date.getFullYear() + ', '+ date.getHours() + ':' + date.getMinutes() + 'PM';

https://jsfiddle.net/bxa5efzj/

answered Mar 2, 2016 at 16:47

Oscar LT

7951 gold badge4 silver badges24 bronze badges

Collectives™ on Stack Overflow

How to change MySQL date format using front end jQuery

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related