echoing date and time

claire

I have a MySql db. One column includes a timestamp when the post was created.

When echoing out that field I get a long string with yyyymmddhhmmss ( 20020619123845 )

I would like to display that string somewhat more readable! (For, example 2002-06-19, 12:38:45)

I tried to make a new $var=date(Y-m-d,H:i:s) but that replaces the stored information with the datetime when the script draws the page on the screen!

I realize that this can probably be done using some kind of string function - but don't know how to do it!

Anon

What I did, which I liked more, because, it's less of a hassle.

I changed my $date variable (date to the test table in mysql) to a text field, and just have the insert code, insert my $datetime which is
$datetime = date("l F d, Y - H:i:s");

The same thing happened to me. With date/datetime in mysql, it will only post like: 2002-06-19 06:41:52

If you want the date, time, day, etc.. you need to use all the mysql options, date, time, day, year.. etc..

Now, since I probably made no sense.

This is my code, that inputs into the mysql dbase.

<?php

$date = date("l F d, Y - H:i:s");

include("mysqlinfo.php");

$result = "INSERT INTO personal_guestbook (date, name, email, url, content_body, topic)
VALUES ('$date', '$name', '$email', '$url', '$content_body', '$topic')";
$result=mysql_query($result);
?>

And with PhpMyAdmin, the $date field is a TEXT, not null.

You can see it for yourself at
http://www.mygaming.org/personal/guestbook.php

Sorry, if this didn't help, I'm somewhat new myself. :-p

claire

Hi, just looked through the topics and realized that you had the same problem!

It seems like a possible way to solve it.... Not as neat as I wanted it to be, but OK....I'll look around a bit more and if I find a better solution will mail it to you!

/thanks!

Anon

dunno if this works but you could give it a try.

<?php
echo date("M,d,Y hⓂs",20020619123845);
?>

claire

I did this

<?php

echo date("M,d,Y hⓂs",$mydate);

?>
where $mydate is the date out of the tbl.

The result?? all entries have the same date and time (year 2038!)

Anon

http://www.php.net/manual/en/function.time.php
http://www.php.net/manual/en/function.date.php

good luck 🙂

Anon

do it like this:
$link = mysql_pconnect('localhost','username','password');
mysql_select_db('database',$link);
$r["day"] = date("Mj g:ia",time() - 10800);
//the "time()-10800" part is adjusting for your local time

foreach(array_keys($r) as $key) { blah blah blah

That puts the date into your mysql table in the format you want to begin with! Then, it's faster to retrieve and parse!

Anon

You should use MySQL's DATE_FORMAT() function:

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Anon

Well, no. It wouldn't; date expects a Unix timestamp, and 20020619123845 is a silly little format. If you're going to try and store a date and time as a single number, why not store it in a form that you can actually work with? Me, I always just store the Unix timestamp as an int (plus, it's smaller).

But anyway.

$mydate = '20020619123845';

list($year, $month, $day, $hour, $minute, $second) = sscanf($mydate,'%4s%2s%2s%2s%2s%2s');

$timestamp = mktime($hour, $minute, $second, $month, $day, $year);

$date = date("M,d,y hⓂs".$timestamp);

echo $date;