converting date to timestamp

[drag0ner]

I need to compare two dates. both are in Y-M-D format. when i do a simple "<=" it is only going to read the first Y, so i need to find a way to convert the Y-M-D format to a timestamp. Anyone know how to do this?
any help would be much appreciated

[drew010]

just use strtotime()

or

mktime()

if you need further help, feel free to post back.

[chads2k2]

Ok... are you using

$today = date("F j, Y");

??

Then just use

$today = date("Ymd");

??

Here is an example I just threw together.

<?php $today = date("Ymd");
$yesterday="20030309";
echo "<br>$today";
echo "<br>$yesterday";

if($today>=$yesterday)
{
    echo "<br>Today is grater than yesterday!";
}
?>

and always check out http://us3.php.net/manual/en/function.date.php

They have all the answers. 🙂

Chad

[drag0ner]

i have a date saved in a mySQL Database. for example - 2003-09-03.

how would i just strip the "-"'s from the string?

[Sxooter]

If you save the date in a proper datetime/timestamp field, then you CAN compare them, and mysql (and any other database as well 🙂) should "do the right thing".

i.e.:

create table test (dt date);
insert into test values ('2003-04-03');
insert into test values ('2003-04-06');
insert into test values ('2003-10-08');
insert into test values ('2002-05-23');
insert into test values ('2001-05-23');
select * from test where dt >'2003-04-04');

[drag0ner]

problem solved. thanks for the help