[Resolved] [Resolved] Timestamp to time format.

AndrewWest

I would like to put a time() in the my database, then pull it out like so:

4:58 pm, Jul 23, 2004

What format would I need to do this in, and possibly an example of the function I'd need to use.

planetsim

Take a look here http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html#IDX1386

AndrewWest

Alright 🙂 Thanks! I couldn't find the right example on php.net (I always look there before asking anyone) but now I'll remember to check mysql too. 🙂

Thanks.

AndrewWest

Can you tell me why exactly this returns an empty time.. when there IS a timestamp in a database

$time = $row['time'];
$post_time = date("g:i a, M j, Y",($time - 24*3600));

Kudose

I would assume becuase $time is not in the same format as needed for date().

echo out $time and then echo out date() in the format you want (without $time) and see if they are similar.

AndrewWest

$time is the same setup as time() and time() works fine. Time() is grabbing current time as a timestamp.. $time grabs the timestamp from the database..

I am using this on a windows server.. and the error I get is..

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970

But it works with time(), because it's not empty, but I'm guesing it's bringing the timestamp in as empty ..

Kudose

What SQL are you using to fetch your array?

Can I see more of your code?

AndrewWest



$post = mysql_query("SELECT * FROM posts WHERE topic=$t ORDER BY id ASC");

/////////////////////////////////////////////////////////////////////////////////////
//// Show the posts /////////////////////////////////////////////////////////////////
while ($row = mysql_fetch_array($post)) {
$i = mysql_query("SELECT * FROM members WHERE name='" .$row['author']. "'");
$info = mysql_fetch_array($i);
$t = mysql_query("SELECT * FROM topics WHERE id='" .$t. "'");
$topic = mysql_fetch_array($t);
$row['author'] = "<a href='./index.php?page=profile&m=" .$row['author']. "'>$row[author]</a>";

/////////////////////////////////////////////////////////////////////////////////////
//// Time of the last post //////////////////////////////////////////////////////////

$time = $row['time'];
$post_time = date("g:i a, M j, Y",($time - 24*3600)); 
}

There ya go. 🙂

Weedpacket

MySQL-style timestamps are a different format from the Un*x-style timestamps that PHP uses. One is just all the bits of a date and time jammed together (e.g., 20040725183200, the other counts how many seconds have elapsed since 1970-01-01 00:00:00.

AndrewWest

Alright thanks for that explanation. I went with a little bit of an unortodox way and entered time() as a varchar(255) and pulled it out like that. Although a lot of the dates .. around wrong. I'm going to find a way to fix that lol.