Convert database timestamp to date

Question

I have a database timestamp with this format 2016-06-01 11:46:00 and I would like to convert and echo it to this format Wed. 01-06-2016.I tried a lot but no desirable results..Any ideas?

Thanks a lot, it worked! If I want the difference between today and the past date in days or weeks I think I use date_diff.How exactly?

score 3 · Accepted Answer · 2016-06-07T08:50:52.140

3

Simply use date and strtotime:

$time = '2016-06-01 11:46:00';
echo date("D. d-m-Y", strtotime($time)); //Wed. 01-06-2016

Updates:

$grk = array("Tet"); // complete the rest of the array
$eng = array("Wed"); // complete the rest of the array

$time = '2016-06-01 11:46:00';
$date = date("D. d-m-Y", strtotime($time));
echo str_replace($eng, $grk, $date);

edited Jun 07 '16 at 08:50

answered Jun 07 '16 at 08:24

he needs like Wed. 01-06-2016. I think you need to update your solution. – Syed mohamed aladeen Jun 07 '16 at 08:25
Updated with the day. – Jun 07 '16 at 08:27
To change `D.` in some day in other languages? – gdim Jun 07 '16 at 08:35
What? I can't catch you. – Jun 07 '16 at 08:38
For example `Wed.` to be replaced with `Tet.` – gdim Jun 07 '16 at 08:43
`Tet.` From where? – Jun 07 '16 at 08:44
Perhaps I will need to create a table with all the days in Greek language.But how can I replace the default days with the days of my array? – gdim Jun 07 '16 at 08:46
@platanas20 did you get the desired output? or are still looking for? – kiran gadhvi Jun 07 '16 at 08:56
1

It worked great!Thanks a lot man! – gdim Jun 07 '16 at 09:27

kiran gadhvi · Answer 2 · 2016-06-07T08:32:03.980

1

$time = '2016-06-01 11:46:00';
echo date("D. d-m-Y", strtotime($time)); //Wed. 01-06-2016

edited Jun 07 '16 at 08:32

answered Jun 07 '16 at 08:27

kiran gadhvi

228
2
16

Thanks a lot.Any ideas how i can echo for example _6 days ago_?I use date_diff but how exactly? – gdim Jun 07 '16 at 08:45
For a different answer you need to make another question, What you ask here is clear. – Jun 07 '16 at 08:46
I updated my question!It is ok I will..Thanks a lot! – gdim Jun 07 '16 at 08:47

Convert database timestamp to date

2 Answers2