SQL Time help

PHP
1

Hello,

What I do want to do is schedule tasks via PHP using SQL database as task list.
I have a filed called “timestamp”, and what I do want to store there is timestamp of when task should go on and than compare it with CURRENT_TIMESTAMP.

I’ve noticed that CURRENT_TIMESTAMP is in format:
2010-05-05 09:26:47

So my question is, how do I get it to work via PHP. Currently I use
$time = time();
$timestamp = $time + ($i*$delay*60)

But when I run mySQL compare timestamp < CURRENT_TIMESTAMP it OC doesn’t work.
So how do I get my $timestamp in proper format?

2

Ok, I hope this would do the trick:
$timestamp = date(“y-m-d H:i:s”, (time() + (60*$delay*$i)));

3

yep, that did the trick.