How to convert timestamp into mm:dd:yy format.

kamill

I have a timestamp type field into my mysql database table. Now threw php i need to change it into mm:dd:yy formate.Threw witch function i can do it. Please help me with an examole. suppose timestamp is this 20070209162211 then how can i convert it into mm:dd:yy formate.
...........
kamill

stephane

date( "d/m/Y", $unix_timestamp);

but 20070209162211 it isn't unix timestamp.
unix timestamp is a number of seconds from 1970 year

stephane

20070209162211 is
2007-02-09 16:22:11

it's more simple to convert. split this string by symbols using substr() and its all

devsusen

unix timestamp and value stored in mysql timestamp datatype are different. There is no such function which can convert mysql timestamp value to mm:dd:yy format.

So its better to use sustr() to get year, month, date, hour, minute, seconds then you can use it. the format for mysql timestamp type is YYYYMMDDhhmmss.

susen

stephane

unix timestamp and value stored in mysql timestamp datatype are different. There is no such function which can convert mysql timestamp value to mm:dd:yy format.
susen

you are wrong
there is a date() function to convert timestamp to every date format
http://www.php.net/date

sunbin

hi,

i have used this code block many times,

Expand|Select|Wrap|Line Numbers

 <?
 
$time_stamp=time(); //gives timestamp

$date_format=date("m:d:y",$time_stamp); // formats timestamp in mm:dd:yy 
 
print $date_format; // results here ... 02 : 11 : 07
 
?>

Solved ???

Sunbin

devsusen

you are wrong
there is a date() function to convert timestamp to every date format
http://www.php.net/date

date() can accept timestamp parameter if it is only unix timestamp not the value stored in mysql table as timestamp datatype.

Susen

ronverdonk

I cannot follow if you had your reply, so I'll throw this one in to convert your YYYYMMDDHHMMSS into MM: DD:YY:

Expand|Select|Wrap|Line Numbers

 echo sprintf("%02s:%02s:%02s", substr($date,4,2),substr($date,6,2),substr($date,2,2));
 

Ronald :cool:

devsusen

I cannot follow if you had your reply, so I'll throw this one in to convert your YYYYMMDDHHMMSS into MM: DD:YY:

Expand|Select|Wrap|Line Numbers

echo sprintf("%02s:%02s:%02s", substr($date,4,2),substr($date,6,2),substr($date,2,2));

Ronald :cool:

I accept this as a good solution.

Susen

ronverdonk

I accept this as a good solution.

Susen

I am so glad you do!

Ronald :cool:

ronlg

I just learned how to do this properly...
What you want to do is have it all handled in your MySQL Query...

In my case, which might not work for you, I have:

Expand|Select|Wrap|Line Numbers

 
$select = array();

$select[] = "MONTH(timeStamp) AS theMonth";

$select[] = "DAY(timeStamp) AS theDay";

That's just part of my query...

Later, when I want to echo the results, I use:

Expand|Select|Wrap|Line Numbers

<?=$results["theMonth"]."/".$results["theDay"];?>

Hopefully this helps. One of our dev. guys just showed it to me and it works like a charm!

billyb

are these examples pulling the timestamp from a database row, and displaying in a new format?

How to convert timestamp into mm:dd:yy format.

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ