[SOLVED] php date from SQL

[Cliftron]

Hey another basic question.

When i post stuff to my db

,NOW())

 

it just inserts a unix timestamp (i think its called)

 

when i get the data from the data base how do i translate from unix time stamp to D/M/Y?

 

[MadTechie]

if your doing it via PHP then

echo date("d/m/y",$timestamp)

 

but for pure SQL then

SELECT DATE_FORMAT(now(),'%e/%m/%y') as formatTime 

 

Hope that helps

[Cliftron]

so would this be correct when i pull it from the db?

$timestamp = $list['Date'];
echo date("d/m/y",$timestamp)

 

[MadTechie]

It really depends on the query,

personally i create an alias

ie

$SQL = "SELECT *, NOW() as theDate FROM table";
$timestamp = $list['theDate'];
echo date("d/m/y",$timestamp)

 

but you can also do this

$SQL = "SELECT *, DATE_FORMAT(now(),'%e/%m/%y') as theDate FROM table";
echo $list['theDate']

[Cliftron]

when i have

$sql = "SELECT *, DATE_FORMAT(now(),'%e/%m/%y') as Date FROM news ORDER BY id DESC LIMIT $offset, $rowsperpage";

echo $list['Date'];

it just shows the current date.

 

[Cliftron]

Never mind i fixed it!

 

Thanks for the help 

[MadTechie]

,

I know you know now, but for others change the now() to the field name of your date