Get readable date from time() sent to database

liam_d · Dec 16, 2007

Hi everyone, just wondering how i can convert a time() that has been sent to a database to a readable date?

Kate · Dec 16, 2007

In mysql you have the date_format function for that purpose

Daniel · Dec 16, 2007

The PHP date function is designed for this.

yuvanextgen · Dec 16, 2007

what is your front end??
use date functions in vb or use visual data manager to do the same

liam_d · Dec 16, 2007

Well you can't sort a mysql query using a date, but you can but a timestamp i was told.

In my forum i update the topics "lastdate" field to a new timestamp when someone replies, and then the forum is sorted by timestamp to show newest topics with replies at the time, the way all forums work.

Albino · Dec 16, 2007

date("d-m-Y", $row['time']);

where $row['time'] is the value from the database, hope that helps a bit

Kate · Dec 16, 2007

Hmmm I think you can indeed sort on a datetime field, but instead display a properly formatted date using date_format for example

liam_d · Dec 16, 2007

Albino said:
date("d-m-Y", $row['time']);

where $row['time'] is the value from the database, hope that helps a bit

That is what i was looking for.

And someone told me exactly why not to use a "date(d-m-y)" thing for sorting stuff, and it was a good idea, so i use timestamps.

edit -> works perfectly as seen on my homepage http://www.altercoder.com/ in the "Latest Forum Posts" block

.

Thanks a lot! :D

Kate · Dec 16, 2007

Something like this:

PHP:

select date_format(lastdate,'%d-%b-%Y %H:%i') as post_date
from [table]
order by lastdate desc

For performance reasons it would be best to do the sorting from SQL, not in PHP code.

yuvanextgen · Dec 16, 2007

liam u asked the question right?
then y urself answering it

liam_d · Dec 16, 2007

yuvanextgen said:
liam u asked the question right?
then y urself answering it

Someone else answered it, if you are even reading this thread properly bud!
And if in future someone answeres there own question, it may be useful someone else if they are doing something the same or similair

sdsinc said:
Something like this:

PHP:

select date_format(lastdate,'%d-%b-%Y %H:%i') as post_date from [table] order by lastdate desc

For performance reasons it would be best to do the sorting from SQL, not in PHP code.

Of course i sort in the sql, but i am using this on the homepage just to show a simple date when the last post was added

(www.altercoder.com).

My actual sql for sorting the topics in the forum is this:

PHP:

mysql_query("SELECT * FROM `forum_topics` WHERE `forumroot` = '" . $_GET['f'] . "' AND `sticky` = '1' ORDER BY `lastdate` DESC");

Thanks again people

copilot.xyz

eilt.com

stackstudio.com

megafrenzy.com

solarshop.com

z3c.com

lostmypass.com

tah.co

3ez.com

iwa.co

Get readable date from time() sent to database

The original NP Emo KidEstablished Member

Domainosaurus RexTop Member

Danltn.comVIP Member

Established Member

The original NP Emo KidEstablished Member

Munky DesignsEstablished Member

Domainosaurus RexTop Member

The original NP Emo KidEstablished Member

Domainosaurus RexTop Member

Established Member

The original NP Emo KidEstablished Member

Yalla.AI

WholesaleCenter.com

SparkDelivery.com

Muuvin.com

Pharmacy.To

rezidans.com

Hearth.net

Robo.io

Enviar.co

Classroom.co

Similar threads

We're social

Yalla.AI

WholesaleCenter.com

SparkDelivery.com

Muuvin.com

Pharmacy.To

rezidans.com

Hearth.net

Robo.io

Enviar.co

Classroom.co

Pinned

Appreciation

Agreement

Answers

Relevance

Reaction

Status

Feeling