Converting mysql time stamp into php

[gurmeet]

Hi friends... I have a table, in which i had stored the date with timestamp... Now i want to retrieve that value into php..plz give me the snippet of code how i can convert this value into proper readable date...

[JasonDFR]

http://www.dynamicdrive.com/forums/s...ad.php?t=42374

If this doesn't answer your question, you are going to have to give more information.

The format of your timestamp in MYSQL would be a good place to start.

I am assuming it is the standarad MySQL datetime, but who knows.

[gurmeet]

ok... then give me sughgestions how i can store date and time in MySQL databse that is easy to retrieve in PHP n i can use it for calculating dates for web page.... means in which format i should save the date value in table..?

[JasonDFR]

This is the format: 2009-03-09 16:43:19

The field TYPE is DATETIME .

[gurmeet]

actually i want to calculate time n dates

suppose sm1 feeds data on 31-10-2009 at 11:00am so "today" with time must b printed on page...and so on..

means on 30-11-09 it must b printed as "on month before" on screen

[james438]

actually i want to calculate time n dates

suppose sm1 feeds data on 31-10-2009 at 11:00am so "today" with time must b printed on page...and so on..

means on 30-11-09 it must b printed as "on month before" on screen

Could you rephrase that using better grammar? I just can't understand what you're trying to say.

I can say that datetime does store both the date and the time into your table.