Date format issue in printing

Question

Possible Duplicate:
Format mysql datetime with php

I have this query:

$sql="SELECT job_id,job,job2,start_date,end_date ".
     "FROM pianificazione WHERE job_id='$selected_jobs'";

the end-date is in a DATE format in the database, but i need to print it in d-m-Y format Here is where i print it:

echo "<td><input type='text'id='end_date'  class='datepicker'  ".
         "title='D-MMM-YYYY' name='end_date[$i]' value='".
          $rows['end_date']. "' /></td>";

Could you please help me with this? Thanks..

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format — Alvin Wong, Oct 05 '12 at 08:44
Check this.. $mydate = strtotime($row->createdate); $dateis = date("m/d/y g:i A", $mydate); — Gopesh Sharma, Oct 05 '12 at 08:51

iLaYa ツ · Answer 1 · 2012-10-05T08:52:44.550

4

You can directly use in mysql query

DATE_FORMAT(end_date,'%d-%m-%Y')

Updated:

DATE_FORMAT(end_date,'%d-%m-%Y') as end_date

edited Oct 05 '12 at 08:52

answered Oct 05 '12 at 08:44

iLaYa ツ

3,941
3
32
48

@Tao fetch using NUM instead of ASSOC will solve the problem, or probably you can create an alias. – Alvin Wong Oct 05 '12 at 08:51
use alias name in your query `DATE_FORMAT(end_date,'%m-%d-%Y') as end_date` – iLaYa ツ Oct 05 '12 at 08:51
Tao was looking for `d-m-Y` btw, not for `m-d-Y`... – Zulakis Oct 05 '12 at 08:52
Now you changed it to `d-d-Y`... – Zulakis Oct 05 '12 at 08:52

score 0 · Answer 2 · answered Oct 05 '12 at 08:44

0

To convert your DATE format $date to a d-m-Y format date use PHPs date() function like this:

$date = date("d-m-Y", strtotime($date));

answered Oct 05 '12 at 08:44

Zulakis

7,859
10
42
67

to me, I prefer it to be done in the query instead – Alvin Wong Oct 05 '12 at 08:52
I tend to keep my queries as clean and short as possible, doing such minor things rather in PHP then inflating your query. – Zulakis Oct 05 '12 at 08:54

score -3 · Answer 3 · edited Nov 15 '12 at 11:56

-3

$date = substr($date_original, 8, 2).'-'.substr($date_original, 5, 2).'-'.substr($date_original, 0, 4);

edited Nov 15 '12 at 11:56

Fahim Parkar

30,974
45
160
276

answered Oct 05 '12 at 08:44

abidibo

4,175
2
25
33

Date format issue in printing

3 Answers3