how to display custom date format from mysql value to php

Question

1.00/5 (1 vote)

See more:

I am having a column date in Mysql table.
date displays like 2014-01-09
Now i need to convert this format to 09-01-2014 and to display in my php file
i used a function in a query like
select str_to_date('date','%d-%m-%Y') from `table_name`;
but i cant get correct
is there any mistake in the above query function format?

Thanks

Posted 8-Jan-14 18:44pm

sivamzcet

Updated 9-Jan-14 1:06am

v2

Add a Solution

4 solutions

Solution 2

There is a full example to be found at http://www.w3resource.com/mysql/date-and-time-functions/mysql-str_to_date-function.php[^]. If that does not work for you then you need to give more details of what results you are seeing.

Posted 9-Jan-14 1:37am

Richard MacCutchan

Solution 4

u can access each an every digit of your date in an array.
so change the sequence of array index to get the desired output
ex:
date=d[0].d[1].'-'.d[2].d[3].'-'.d[4].d[5].d[6].d[7];(date format DD-MM-YYYY)

similaryly
date=d[4].d[5].d[6].d[7].'-'.d[2].d[3].'-'.d[0].d[1];(date format YYYY-MM-DD)

Posted 16-Jan-14 21:10pm

Abhi Ceivea

Solution 3

select date_format(`date`,'%d-%m-%Y')

Posted 9-Jan-14 6:54am

sivamzcet

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bojjaiah · Accepted Answer · 2014-01-09T01:37:00

Solution 1

Date time formate[^]

Date Time Formate[^]

PHP

$date = new DateTime('2014-01-09');
echo $date->format('d-m-Y');

Posted 9-Jan-14 1:37am

Bojjaiah

Updated 9-Jan-14 1:44am

v2