rockmansattic
asked on
sql epoch to php time()
Total brain fart..
What is the correct converson for sql to php time()?
This is needed,
WHERE (now()-15552000<datesubmit ted)
datesubmitted is generated by time()
Thanks
What is the correct converson for sql to php time()?
This is needed,
WHERE (now()-15552000<datesubmit
datesubmitted is generated by time()
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
just a little tweaking
to
WHERE DAYOFYEAR(now())-180 < DAYOFYEAR(FROM_UNIXTIME(da tesubmitte d))
Rockman
just a little tweaking
to
WHERE DAYOFYEAR(now())-180 < DAYOFYEAR(FROM_UNIXTIME(da
Rockman
ASKER
Although, I will look into converting it from there.
Rockman