Help with date / time

adammc

Hi Folks,

I was hoping for a bit of help on how to extract date / time from my MYSQL database into the correct time format.

I am using this code to insert into a datetime table:

<?php echo date("Y/m/d @ H:i:s"); ?>

I would like to echo it onto my page putting converting it to Australian Date / Time (+10 hours - 25-12-2006 10.30pm)

Any help would be greatly appreciated 🙂

devinemke

SELECT DATE_FORMAT(DATE_ADD(date_field, INTERVAL 10 hour), '%Y/%m/%d @ %H:%i:%s') AS date

adammc

Hi,

thank you for the reply 🙂

Can you please explain what these are🙁which are php functions and which are my variables and table rows)

DATE_FORMAT
DATE_ADD
date_field
AS date

devinemke

adammc wrote:
which are php functions and which are my variables and table rows

none of them are PHP functions. you do not want/need to do any of this in PHP. it all can and should be done directly from the query. read up on mySQL's Date and Time Functions.