Help with the time!

[geniuscrew]

Hi I need help with times -

I have a table which contains records. I also have an "airdate" field.

In the field goes a date and a time.

I would like to know how to display the records based on the date today.

I think it involves comparing todays date with the value in the field but I'm not sure

Edited to add: I also would like to know how to display GMT time in the format

PHP Code:

$today = date("F j, Y, g:i a"); 


- this isn't the server time however, the server is EST.

Thanx!

[tHE DSS]

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=43272" target="_blank">https://vborg.vbsupport.ru/showt...threadid=43272</a>

... i've put some handy time pieces there.

[geniuscrew]

Thankyou - I'll go check it out =)

Edited to add:

Thanx but it looks like that only applies to vBulletin - I need this for my site :-/

Also how would I display the records according to today's date?


Thanx for your help

[Scott MacVicar]

I'd store a unix timestamp because then they have a numeric timestamp then probably.

$time = time();

SELECT * FROM table WHERE date>time ORDER BY date ASC

That will select the rows from table where the date is greater than time and order with the closest date at the top.

[geniuscrew]

Thanx -

Will it matter what format the date is in, in the DB?