Change date format (in DB or output) to dd/mm/yyyy

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?

I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

edited Sep 27 '13 at 18:07

John Conde

187k80376430

asked Mar 19 '10 at 19:53

Jess

86117

add a comment |

MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?

I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

edited Sep 27 '13 at 18:07

John Conde

187k80376430

asked Mar 19 '10 at 19:53

Jess

86117

add a comment |

MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?

I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

edited Sep 27 '13 at 18:07

John Conde

187k80376430

asked Mar 19 '10 at 19:53

Jess

86117

MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?

I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

php mysql sql date

edited Sep 27 '13 at 18:07

John Conde

187k80376430

asked Mar 19 '10 at 19:53

Jess

86117

edited Sep 27 '13 at 18:07

John Conde

187k80376430

asked Mar 19 '10 at 19:53

Jess

86117

edited Sep 27 '13 at 18:07

John Conde

187k80376430

edited Sep 27 '13 at 18:07

John Conde

187k80376430

edited Sep 27 '13 at 18:07

John Conde

187k80376430

asked Mar 19 '10 at 19:53

Jess

86117

asked Mar 19 '10 at 19:53

Jess

86117

asked Mar 19 '10 at 19:53

Jess

86117

add a comment |

8 Answers
8

active

oldest

votes

In PHP, you could :

Transform the date to a timestamp, using strtotime

Format it, using date

A bit like this, I'd say :

$timestamp = strtotime($date_from_db);

echo date('d/m/Y', $timestamp);

But this will only work for dates between 1970 and 2038, as timestamps are stored as 32 bits integers, counting from 1970-01-01.

In MySQL, I suppose the date_format function would do the trick.

For example :

mysql> select date_format(curdate(), '%d/%m/%Y');

+------------------------------------+

| date_format(curdate(), '%d/%m/%Y') |

+------------------------------------+

| 19/03/2010                         |

+------------------------------------+

1 row in set (0.03 sec)

And, for the sake of completness, another solution, in PHP, that doesn't suffer from the limitation of 1970-2038 would be to use the DateTime class, and, especially :

DateTime::__construct to parse the date returned by the DB

DateTime::format to format the date to whatever format you want.

For example, this portion of code :

$date = new DateTime('2010-03-19');

echo $date->format('d/m/Y');

would get you this output :

19/03/2010

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

Where do I use this date function and how?

– Jess
Mar 19 '10 at 19:58

I've edited my answer to add more informations ; is your comment-question still valid ? If yes, which possible solution does "this date function" refer to ?

– Pascal MARTIN
Mar 19 '10 at 20:02

I'm just a bit confused where I insert it! :S Sorry, I'll have have a play and work it out :)

– Jess
Mar 19 '10 at 20:12

If you choose one of the PHP solutions, you can do that somewhere arround your display, as it's a matter of presentation ;;; if you choose the SQL solution, well, obvisouly, you'll do that in your SQL query (But considering this is presentation, I would prefer having this in the view/template, in PHP)

– Pascal MARTIN
Mar 19 '10 at 20:14

Ok, what would you say is the best solution to use if I am planning on sorting the table rows by date (afterwards), and also running a query that displays items with dates that have passed a deadline, from what the system date is (if that makes sense)... e.g. system date is set as 20th march 2010, a deadline for activity is set as 21st march...i plan on changing the colour of the table row to red (just an example) to shows its passed date! Will using PHP or MySQL to format the date make any difference to my requirment?

– Jess
Mar 19 '10 at 20:25

|
show 3 more comments

Just use the Mysql built in function DATE_FORMAT()

SELECT DATE_FORMAT(some_date_field, "Y/m/d");

answered Mar 19 '10 at 19:56

John Conde

187k80376430

1

This, except the format is wrong in the example. :)

– Mikael S
Mar 19 '10 at 20:06

@MikaelS which is the correct?

– candlejack
Apr 14 '17 at 5:25

add a comment |

You can display you date in any format you want in your pages, in mysql i realy don't know, in php you can use this function: date ( string $format [, int $timestamp ] ). So you can do this:

echo date( "d/m/Y", strtotime ( $your_date ) );

You can find full description here: http://php.net/manual/en/function.date.php

answered Mar 19 '10 at 20:06

D.Martin

861

add a comment |

After getting it from the DB, use $time = strtotime($value) to convert it to a timestamp in PHP. Then use date("d/m/Y", $time) to get it in that format.

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

add a comment |

If you used some Framework like Zend, it would be very easy because you have plenty of classes to handle databases and date formatting. Then you would always see the output as the Brazilian date format. Just like Delphi TDateField uses Windows date format in the current computer, Zend will look up in your own configuration.

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

add a comment |

i'm using this script and put it on upper line.

$(function(){

    var pickerOpts = {

        dateFormat: "yy-mm-dd"

    };  

    $("#datepicker").datepicker(pickerOpts);

});

and this one in your form.

<input id=**"datepicker" type="date"** name="Start"  size="9" value="<?php  



echo $Start;



?>" />

It will appear as d/m/y on your page but in your database y/m/d.

edited Apr 5 '16 at 1:57

Chaithanya

95621527

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

add a comment |

This mysql function will return the correct format in the result

SELECT DATE_FORMAT(date_field, "%M %d %Y");

answered Mar 21 '18 at 14:24

Nandhini

447

add a comment |

$dtShowDate = $_POST['dtShowDate']; $date =explode('-', $dtShowDate)0; $showdate = $date[2]."-".$date[0]."-".$date[1];

Set Date as per your need

edited Jan 3 at 7:29

Akash Dubey

610827

answered Jan 3 at 7:03

Keval Mehta

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f2480186%2fchange-date-format-in-db-or-output-to-dd-mm-yyyy-php-mysql%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

8 Answers
8

active

oldest

votes

8 Answers
8

active

oldest

votes

In PHP, you could :

Transform the date to a timestamp, using strtotime

Format it, using date

A bit like this, I'd say :

$timestamp = strtotime($date_from_db);

echo date('d/m/Y', $timestamp);

But this will only work for dates between 1970 and 2038, as timestamps are stored as 32 bits integers, counting from 1970-01-01.

In MySQL, I suppose the date_format function would do the trick.

For example :

mysql> select date_format(curdate(), '%d/%m/%Y');

+------------------------------------+

| date_format(curdate(), '%d/%m/%Y') |

+------------------------------------+

| 19/03/2010                         |

+------------------------------------+

1 row in set (0.03 sec)

And, for the sake of completness, another solution, in PHP, that doesn't suffer from the limitation of 1970-2038 would be to use the DateTime class, and, especially :

DateTime::__construct to parse the date returned by the DB

DateTime::format to format the date to whatever format you want.

For example, this portion of code :

$date = new DateTime('2010-03-19');

echo $date->format('d/m/Y');

would get you this output :

19/03/2010

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

Where do I use this date function and how?

– Jess
Mar 19 '10 at 19:58

I've edited my answer to add more informations ; is your comment-question still valid ? If yes, which possible solution does "this date function" refer to ?

– Pascal MARTIN
Mar 19 '10 at 20:02

I'm just a bit confused where I insert it! :S Sorry, I'll have have a play and work it out :)

– Jess
Mar 19 '10 at 20:12

If you choose one of the PHP solutions, you can do that somewhere arround your display, as it's a matter of presentation ;;; if you choose the SQL solution, well, obvisouly, you'll do that in your SQL query (But considering this is presentation, I would prefer having this in the view/template, in PHP)

– Pascal MARTIN
Mar 19 '10 at 20:14

Ok, what would you say is the best solution to use if I am planning on sorting the table rows by date (afterwards), and also running a query that displays items with dates that have passed a deadline, from what the system date is (if that makes sense)... e.g. system date is set as 20th march 2010, a deadline for activity is set as 21st march...i plan on changing the colour of the table row to red (just an example) to shows its passed date! Will using PHP or MySQL to format the date make any difference to my requirment?

– Jess
Mar 19 '10 at 20:25

|
show 3 more comments

In PHP, you could :

Transform the date to a timestamp, using strtotime

Format it, using date

A bit like this, I'd say :

$timestamp = strtotime($date_from_db);

echo date('d/m/Y', $timestamp);

But this will only work for dates between 1970 and 2038, as timestamps are stored as 32 bits integers, counting from 1970-01-01.

In MySQL, I suppose the date_format function would do the trick.

For example :

mysql> select date_format(curdate(), '%d/%m/%Y');

+------------------------------------+

| date_format(curdate(), '%d/%m/%Y') |

+------------------------------------+

| 19/03/2010                         |

+------------------------------------+

1 row in set (0.03 sec)

And, for the sake of completness, another solution, in PHP, that doesn't suffer from the limitation of 1970-2038 would be to use the DateTime class, and, especially :

DateTime::__construct to parse the date returned by the DB

DateTime::format to format the date to whatever format you want.

For example, this portion of code :

$date = new DateTime('2010-03-19');

echo $date->format('d/m/Y');

would get you this output :

19/03/2010

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

Where do I use this date function and how?

– Jess
Mar 19 '10 at 19:58

I've edited my answer to add more informations ; is your comment-question still valid ? If yes, which possible solution does "this date function" refer to ?

– Pascal MARTIN
Mar 19 '10 at 20:02

I'm just a bit confused where I insert it! :S Sorry, I'll have have a play and work it out :)

– Jess
Mar 19 '10 at 20:12

If you choose one of the PHP solutions, you can do that somewhere arround your display, as it's a matter of presentation ;;; if you choose the SQL solution, well, obvisouly, you'll do that in your SQL query (But considering this is presentation, I would prefer having this in the view/template, in PHP)

– Pascal MARTIN
Mar 19 '10 at 20:14

Ok, what would you say is the best solution to use if I am planning on sorting the table rows by date (afterwards), and also running a query that displays items with dates that have passed a deadline, from what the system date is (if that makes sense)... e.g. system date is set as 20th march 2010, a deadline for activity is set as 21st march...i plan on changing the colour of the table row to red (just an example) to shows its passed date! Will using PHP or MySQL to format the date make any difference to my requirment?

– Jess
Mar 19 '10 at 20:25

|
show 3 more comments

In PHP, you could :

Transform the date to a timestamp, using strtotime

Format it, using date

A bit like this, I'd say :

$timestamp = strtotime($date_from_db);

echo date('d/m/Y', $timestamp);

But this will only work for dates between 1970 and 2038, as timestamps are stored as 32 bits integers, counting from 1970-01-01.

In MySQL, I suppose the date_format function would do the trick.

For example :

mysql> select date_format(curdate(), '%d/%m/%Y');

+------------------------------------+

| date_format(curdate(), '%d/%m/%Y') |

+------------------------------------+

| 19/03/2010                         |

+------------------------------------+

1 row in set (0.03 sec)

And, for the sake of completness, another solution, in PHP, that doesn't suffer from the limitation of 1970-2038 would be to use the DateTime class, and, especially :

DateTime::__construct to parse the date returned by the DB

DateTime::format to format the date to whatever format you want.

For example, this portion of code :

$date = new DateTime('2010-03-19');

echo $date->format('d/m/Y');

would get you this output :

19/03/2010

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

In PHP, you could :

Transform the date to a timestamp, using strtotime

Format it, using date

A bit like this, I'd say :

$timestamp = strtotime($date_from_db);

echo date('d/m/Y', $timestamp);

But this will only work for dates between 1970 and 2038, as timestamps are stored as 32 bits integers, counting from 1970-01-01.

In MySQL, I suppose the date_format function would do the trick.

For example :

mysql> select date_format(curdate(), '%d/%m/%Y');

+------------------------------------+

| date_format(curdate(), '%d/%m/%Y') |

+------------------------------------+

| 19/03/2010                         |

+------------------------------------+

1 row in set (0.03 sec)

And, for the sake of completness, another solution, in PHP, that doesn't suffer from the limitation of 1970-2038 would be to use the DateTime class, and, especially :

DateTime::__construct to parse the date returned by the DB

DateTime::format to format the date to whatever format you want.

For example, this portion of code :

$date = new DateTime('2010-03-19');

echo $date->format('d/m/Y');

would get you this output :

19/03/2010

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

answered Mar 19 '10 at 19:57

Pascal MARTIN

341k59589616

Where do I use this date function and how?

– Jess
Mar 19 '10 at 19:58

I've edited my answer to add more informations ; is your comment-question still valid ? If yes, which possible solution does "this date function" refer to ?

– Pascal MARTIN
Mar 19 '10 at 20:02

I'm just a bit confused where I insert it! :S Sorry, I'll have have a play and work it out :)

– Jess
Mar 19 '10 at 20:12

If you choose one of the PHP solutions, you can do that somewhere arround your display, as it's a matter of presentation ;;; if you choose the SQL solution, well, obvisouly, you'll do that in your SQL query (But considering this is presentation, I would prefer having this in the view/template, in PHP)

– Pascal MARTIN
Mar 19 '10 at 20:14

Ok, what would you say is the best solution to use if I am planning on sorting the table rows by date (afterwards), and also running a query that displays items with dates that have passed a deadline, from what the system date is (if that makes sense)... e.g. system date is set as 20th march 2010, a deadline for activity is set as 21st march...i plan on changing the colour of the table row to red (just an example) to shows its passed date! Will using PHP or MySQL to format the date make any difference to my requirment?

– Jess
Mar 19 '10 at 20:25

|
show 3 more comments

Where do I use this date function and how?

– Jess
Mar 19 '10 at 19:58

I've edited my answer to add more informations ; is your comment-question still valid ? If yes, which possible solution does "this date function" refer to ?

– Pascal MARTIN
Mar 19 '10 at 20:02

I'm just a bit confused where I insert it! :S Sorry, I'll have have a play and work it out :)

– Jess
Mar 19 '10 at 20:12

If you choose one of the PHP solutions, you can do that somewhere arround your display, as it's a matter of presentation ;;; if you choose the SQL solution, well, obvisouly, you'll do that in your SQL query (But considering this is presentation, I would prefer having this in the view/template, in PHP)

– Pascal MARTIN
Mar 19 '10 at 20:14

Ok, what would you say is the best solution to use if I am planning on sorting the table rows by date (afterwards), and also running a query that displays items with dates that have passed a deadline, from what the system date is (if that makes sense)... e.g. system date is set as 20th march 2010, a deadline for activity is set as 21st march...i plan on changing the colour of the table row to red (just an example) to shows its passed date! Will using PHP or MySQL to format the date make any difference to my requirment?

– Jess
Mar 19 '10 at 20:25

Where do I use this date function and how?

– Jess
Mar 19 '10 at 19:58

I've edited my answer to add more informations ; is your comment-question still valid ? If yes, which possible solution does "this date function" refer to ?

– Pascal MARTIN
Mar 19 '10 at 20:02

I'm just a bit confused where I insert it! :S Sorry, I'll have have a play and work it out :)

– Jess
Mar 19 '10 at 20:12

If you choose one of the PHP solutions, you can do that somewhere arround your display, as it's a matter of presentation ;;; if you choose the SQL solution, well, obvisouly, you'll do that in your SQL query (But considering this is presentation, I would prefer having this in the view/template, in PHP)

– Pascal MARTIN
Mar 19 '10 at 20:14

Ok, what would you say is the best solution to use if I am planning on sorting the table rows by date (afterwards), and also running a query that displays items with dates that have passed a deadline, from what the system date is (if that makes sense)... e.g. system date is set as 20th march 2010, a deadline for activity is set as 21st march...i plan on changing the colour of the table row to red (just an example) to shows its passed date! Will using PHP or MySQL to format the date make any difference to my requirment?

– Jess
Mar 19 '10 at 20:25

|
show 3 more comments

Just use the Mysql built in function DATE_FORMAT()

SELECT DATE_FORMAT(some_date_field, "Y/m/d");

answered Mar 19 '10 at 19:56

John Conde

187k80376430

1

This, except the format is wrong in the example. :)

– Mikael S
Mar 19 '10 at 20:06

@MikaelS which is the correct?

– candlejack
Apr 14 '17 at 5:25

add a comment |

Just use the Mysql built in function DATE_FORMAT()

SELECT DATE_FORMAT(some_date_field, "Y/m/d");

answered Mar 19 '10 at 19:56

John Conde

187k80376430

1

This, except the format is wrong in the example. :)

– Mikael S
Mar 19 '10 at 20:06

@MikaelS which is the correct?

– candlejack
Apr 14 '17 at 5:25

add a comment |

Just use the Mysql built in function DATE_FORMAT()

SELECT DATE_FORMAT(some_date_field, "Y/m/d");

answered Mar 19 '10 at 19:56

John Conde

187k80376430

Just use the Mysql built in function DATE_FORMAT()

SELECT DATE_FORMAT(some_date_field, "Y/m/d");

answered Mar 19 '10 at 19:56

John Conde

187k80376430

answered Mar 19 '10 at 19:56

John Conde

187k80376430

answered Mar 19 '10 at 19:56

John Conde

187k80376430

answered Mar 19 '10 at 19:56

John Conde

187k80376430

1

This, except the format is wrong in the example. :)

– Mikael S
Mar 19 '10 at 20:06

@MikaelS which is the correct?

– candlejack
Apr 14 '17 at 5:25

add a comment |

1

This, except the format is wrong in the example. :)

– Mikael S
Mar 19 '10 at 20:06

@MikaelS which is the correct?

– candlejack
Apr 14 '17 at 5:25

This, except the format is wrong in the example. :)

– Mikael S
Mar 19 '10 at 20:06

@MikaelS which is the correct?

– candlejack
Apr 14 '17 at 5:25

add a comment |

You can display you date in any format you want in your pages, in mysql i realy don't know, in php you can use this function: date ( string $format [, int $timestamp ] ). So you can do this:

echo date( "d/m/Y", strtotime ( $your_date ) );

You can find full description here: http://php.net/manual/en/function.date.php

answered Mar 19 '10 at 20:06

D.Martin

861

add a comment |

You can display you date in any format you want in your pages, in mysql i realy don't know, in php you can use this function: date ( string $format [, int $timestamp ] ). So you can do this:

echo date( "d/m/Y", strtotime ( $your_date ) );

You can find full description here: http://php.net/manual/en/function.date.php

answered Mar 19 '10 at 20:06

D.Martin

861

add a comment |

You can display you date in any format you want in your pages, in mysql i realy don't know, in php you can use this function: date ( string $format [, int $timestamp ] ). So you can do this:

echo date( "d/m/Y", strtotime ( $your_date ) );

You can find full description here: http://php.net/manual/en/function.date.php

answered Mar 19 '10 at 20:06

D.Martin

861

You can display you date in any format you want in your pages, in mysql i realy don't know, in php you can use this function: date ( string $format [, int $timestamp ] ). So you can do this:

echo date( "d/m/Y", strtotime ( $your_date ) );

You can find full description here: http://php.net/manual/en/function.date.php

answered Mar 19 '10 at 20:06

D.Martin

861

answered Mar 19 '10 at 20:06

D.Martin

861

answered Mar 19 '10 at 20:06

D.Martin

861

answered Mar 19 '10 at 20:06

D.Martin

861

add a comment |

After getting it from the DB, use $time = strtotime($value) to convert it to a timestamp in PHP. Then use date("d/m/Y", $time) to get it in that format.

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

add a comment |

After getting it from the DB, use $time = strtotime($value) to convert it to a timestamp in PHP. Then use date("d/m/Y", $time) to get it in that format.

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

add a comment |

After getting it from the DB, use $time = strtotime($value) to convert it to a timestamp in PHP. Then use date("d/m/Y", $time) to get it in that format.

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

After getting it from the DB, use $time = strtotime($value) to convert it to a timestamp in PHP. Then use date("d/m/Y", $time) to get it in that format.

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

answered Mar 19 '10 at 19:57

St. John Johnson

5,47373054

add a comment |

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

add a comment |

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

add a comment |

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

answered Mar 1 '13 at 12:17

Please_Dont_Bully_Me_SO_Lords

3,7411259113

add a comment |

i'm using this script and put it on upper line.

$(function(){

    var pickerOpts = {

        dateFormat: "yy-mm-dd"

    };  

    $("#datepicker").datepicker(pickerOpts);

});

and this one in your form.

<input id=**"datepicker" type="date"** name="Start"  size="9" value="<?php  



echo $Start;



?>" />

It will appear as d/m/y on your page but in your database y/m/d.

edited Apr 5 '16 at 1:57

Chaithanya

95621527

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

add a comment |

i'm using this script and put it on upper line.

$(function(){

    var pickerOpts = {

        dateFormat: "yy-mm-dd"

    };  

    $("#datepicker").datepicker(pickerOpts);

});

and this one in your form.

<input id=**"datepicker" type="date"** name="Start"  size="9" value="<?php  



echo $Start;



?>" />

It will appear as d/m/y on your page but in your database y/m/d.

edited Apr 5 '16 at 1:57

Chaithanya

95621527

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

add a comment |

i'm using this script and put it on upper line.

$(function(){

    var pickerOpts = {

        dateFormat: "yy-mm-dd"

    };  

    $("#datepicker").datepicker(pickerOpts);

});

and this one in your form.

<input id=**"datepicker" type="date"** name="Start"  size="9" value="<?php  



echo $Start;



?>" />

It will appear as d/m/y on your page but in your database y/m/d.

edited Apr 5 '16 at 1:57

Chaithanya

95621527

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

i'm using this script and put it on upper line.

$(function(){

    var pickerOpts = {

        dateFormat: "yy-mm-dd"

    };  

    $("#datepicker").datepicker(pickerOpts);

});

and this one in your form.

<input id=**"datepicker" type="date"** name="Start"  size="9" value="<?php  



echo $Start;



?>" />

It will appear as d/m/y on your page but in your database y/m/d.

edited Apr 5 '16 at 1:57

Chaithanya

95621527

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

edited Apr 5 '16 at 1:57

Chaithanya

95621527

edited Apr 5 '16 at 1:57

Chaithanya

95621527

edited Apr 5 '16 at 1:57

Chaithanya

95621527

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

answered Apr 5 '16 at 1:12

Nurfaezah Hanis

111

add a comment |

This mysql function will return the correct format in the result

SELECT DATE_FORMAT(date_field, "%M %d %Y");

answered Mar 21 '18 at 14:24

Nandhini

447

add a comment |

This mysql function will return the correct format in the result

SELECT DATE_FORMAT(date_field, "%M %d %Y");

answered Mar 21 '18 at 14:24

Nandhini

447

add a comment |

This mysql function will return the correct format in the result

SELECT DATE_FORMAT(date_field, "%M %d %Y");

answered Mar 21 '18 at 14:24

Nandhini

447

This mysql function will return the correct format in the result

SELECT DATE_FORMAT(date_field, "%M %d %Y");

answered Mar 21 '18 at 14:24

Nandhini

447

answered Mar 21 '18 at 14:24

Nandhini

447

answered Mar 21 '18 at 14:24

Nandhini

447

answered Mar 21 '18 at 14:24

Nandhini

447

add a comment |

$dtShowDate = $_POST['dtShowDate']; $date =explode('-', $dtShowDate)0; $showdate = $date[2]."-".$date[0]."-".$date[1];

Set Date as per your need

edited Jan 3 at 7:29

Akash Dubey

610827

answered Jan 3 at 7:03

Keval Mehta

add a comment |

$dtShowDate = $_POST['dtShowDate']; $date =explode('-', $dtShowDate)0; $showdate = $date[2]."-".$date[0]."-".$date[1];

Set Date as per your need

edited Jan 3 at 7:29

Akash Dubey

610827

answered Jan 3 at 7:03

Keval Mehta

add a comment |

$dtShowDate = $_POST['dtShowDate']; $date =explode('-', $dtShowDate)0; $showdate = $date[2]."-".$date[0]."-".$date[1];

Set Date as per your need

edited Jan 3 at 7:29

Akash Dubey

610827

answered Jan 3 at 7:03

Keval Mehta

$dtShowDate = $_POST['dtShowDate']; $date =explode('-', $dtShowDate)0; $showdate = $date[2]."-".$date[0]."-".$date[1];

Set Date as per your need

edited Jan 3 at 7:29

Akash Dubey

610827

answered Jan 3 at 7:03

Keval Mehta

edited Jan 3 at 7:29

Akash Dubey

610827

edited Jan 3 at 7:29

Akash Dubey

610827

edited Jan 3 at 7:29

Akash Dubey

610827

answered Jan 3 at 7:03

Keval Mehta

answered Jan 3 at 7:03

Keval Mehta

answered Jan 3 at 7:03

Keval Mehta

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu