Get date from database in php

Question

i am storing date and time in database using php using gmdate() function in format "Y-m-d H:i:s". for e.g.

2014-03-10 12:35:55

Now,on getting this data into a php variable,for e.g.

$temp=2014-03-10 12:35:55

can i extract and display only the DATE portion excluding the TIME portion?? I am new to date and time manipulation.Any help?

Why not using Time, Date, Year in seperate coloumn $date = date('d'); $month = date('m'); $year = date('Y'); — Sulthan Allaudeen, Mar 19 '14 at 11:17

echo_Me · Accepted Answer · 2014-03-19T11:40:56.710

4

you can get directly the date from database like this

select DATE(column_datetime) as date from yourtable

edited Mar 19 '14 at 11:40

answered Mar 19 '14 at 11:16

echo_Me

user3004356 · Answer 2 · 2014-03-19T11:42:34.313

0

date('Y-m-d', strtotime($temp));

The above statement returns the date from datetime format

edited Mar 19 '14 at 11:42

answered Mar 19 '14 at 11:17

user3004356

This won't work because `date` is expecting an integer UNIX timestamp as second argument: http://php.net/manual/en/function.date.php – secelite Mar 19 '14 at 11:19
As secelite told it takes UNIX timestamp, try the updated one now, it is simple – user3004356 Mar 19 '14 at 11:23
Never heard of DateTime class that lets you create a DateTime object using arbitrary format? I won't downvote you but using explode... it's just bad. – N.B. Mar 19 '14 at 11:25
@N.B. I have changed my answer – user3004356 Mar 19 '14 at 11:32

score 0 · Answer 3 · edited Mar 19 '14 at 11:41

0

As Pramod answered,

date('Y-m-d', strtotime($temp));

works.

edited Mar 19 '14 at 11:41

user3004356

answered Mar 19 '14 at 11:28

Ankur

A little note to that http://stackoverflow.com/questions/113829/how-to-convert-date-to-timestamp-in-php#115864 – secelite Mar 19 '14 at 11:42
its not safe to use strtotime but strptime is not available for windows.whats the solution now? – Ankur Mar 19 '14 at 11:49

score 0 · Answer 4 · edited May 23 '17 at 10:31

The following code example is adapted by this thread: How to convert date to timestamp in PHP?

There you can also read why it is not safe to rely on strtotime (answer by daremon)

$temp = '2014-03-10 12:35:55';
$a = strptime($temp, '%Y-%m-%d');
$timestamp = mktime(0, 0, 0, $a['tm_mon']+1, $a['tm_mday'], $a['tm_year']+1900);

Edit

From the PHP manual

Note: This function is not implemented on Windows platforms.

K.W. · Answer 5 · 2014-03-19T11:27:23.443

-1

Try this:

Echo date('Y-M-D', $var);

edited Mar 19 '14 at 11:27

answered Mar 19 '14 at 11:18

K.W.

5 Answers5