Date function

riyaz123

Hi all,

I want to get today's date from PHP. That function should return this date in date format not in string. Because i want to compare this with a date of mysql.

Is there any suitable function for this.

Thanks in Advance

Riaz Thad

toma42

in mysql
select unix_timestamp(somedate) as mydate from sometable;

$x = $db->mydate

if (time() > $x) { // do something }

riyaz123

I want to check todays's date with a date field.

suppose
$x=date('d-m-Y');

Can I convert this string to date format ?

Riaz

riyaz123

$a=date('Y-m-d');
$a=strtotime($a);
select unix_timestamp(field) as myfield from table
if($a>$db->myfield)
{do something}

Am I correct ?

Thanks for your unix_timestamp.

Riaz