Convert MySQL date format to DD/MM/YY date format using Javascript

Question

I was wondering how I would go about converting the SQL timestamp format (2016-04-30T01:19:45.000Z) to a standard date format like (30/04/2016) using Javascript/front-end-technology.

Thanks in advance.

first do this var d = new Date(mysqldate) do this d.getDate() which return date of month than d.getMonth() and than get year with d.getFullYear() — uzaif
– uzaif, Commented Apr 30, 2016 at 2:42

Sankar Krishnamoorthy · Accepted Answer · 2016-04-30 02:44:23Z

9

Hope this helps. This can be achieved in multiple ways - pure JavaScript, jQuery, Angular etc., As well it requires bit of tweaking based on your requirement. Do let me know if this helps

<script>
        var myDate = new Date('2010-10-11T00:00:00+05:30');
        alert((myDate.getMonth() + 1) + '/' + myDate.getDate() + '/' + myDate.getFullYear());
    </script>

answered Apr 30, 2016 at 2:44

Sankar Krishnamoorthy

1,33513 silver badges19 bronze badges

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

2 Comments

Sarah Macey Over a year ago

Incredible! Thank you! :)

cloudxix Over a year ago

my bootstrap datepicker didn't like the dates unless they were padded with leading zeros. I modified your solution which solved my issue. thanks.

Max Kroshka · Accepted Answer · 2016-04-30 02:50:34Z

4

It depends on how many operations you want to do. If it is more than one, then i would recommend using a library like momentJS. It makes timestamp conversion very simple. See example below.

MySQL date string:

var sqlDate = new Date('2016-04-30T01:19:45.000z');
var now = moment(sqlDate).format('l');
console.log( now );

edited Apr 30, 2016 at 2:50

answered Apr 30, 2016 at 2:40

Max Kroshka

4972 silver badges5 bronze badges

1 Comment

Sarah Macey Over a year ago

Thanks! I've got quite a few libraries running already because I've been getting a bit lazy so I'm trying to avoid anymore - but regardless thank you for your response. :)

Collectives™ on Stack Overflow

Convert MySQL date format to DD/MM/YY date format using Javascript

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related