How can I add php function to SQL

Techissue2008

How can I write the SQL for strtotime()?

Here is my SQL for mysql:

"SELECT t1.jobname, t1.startdate, t2.completedate FROM account AS t1, job as t2 where {strtotime(t1.startdate)} < {strtotime(t2.completedate)}";

I just want to show those job which completedate > startdate.

However, it does not work with that sql. How can I add php function to SQL?

Techissue2008

The startdate and completedate columns in those tables are datetime.

If strtotime(2008-04-21 21:01:34), it returns 1208811694

2008-04-22 22:17:01 -> 1208902621

May I ask what does the return value of strtotime represent?

NogDog

It returns UNIX timestamp integer, which is the number of seconds since the "UNIX epoch" (1970/01/01-00:00:00 UTC).

Weedpacket

NogDog wrote:
It returns UNIX timestamp integer, which is the number of seconds since the "UNIX epoch" (1970/01/01-00:00:00 UTC).

Or, to quote the manual page entry for [man]strtotime[/man]:

a Unix timestamp (the number of seconds since January 1 1970 00:00:00 GMT)

It's amazing what you can learn if you just rub a few brain cells together and think "I know, I'll RTFM and see if that says anything."

Techissue2008

I thought my logic was incorrect. In select sql, it selects it from DB with where condition completedate > startdate and execute strtodate(). But, not execute strtodate() and select with completedate > startdate condition.

So, I changed all input date by the following:

$y = "0";
$ym = $y * 60; 
$my = $ym * 60;
$gmdate = gmdate("YmdHis", time()+($my));

It shows the bigint 20080423182214. It is int type now.

However, the completedate > startdate condition still not work and show all records.

Any advice?

Techissue2008

BTW, I changed the data type bigint in all columns of tables

Techissue2008

Thanks for help. I found out it is SQL problem. The bigint data can be compared now.

bradgrafelman

Don't forget to mark this thread resolved.