mySQL.. help please :)

JAY-ESSENTIAL · 24 Sep 2009 at 16:26

I need to view all records which are in the range : (today + one month)
dateline_from is my date time (UNIX format).

I know how to convert UNIX to normal date time its FROM_UNIXTIME(date,format).

How would i do this... Using MySql ??

a bit of statment which might help

SELECT * FROM `event` WHERE FROM_UNIXTIME( `dateline_from` , format)

daz · 24 Sep 2009 at 16:47

If you're using 31 days as a month, just do everything from now() to now() + (86400 x 31)

JAY-ESSENTIAL · 24 Sep 2009 at 18:53

daz said:
If you're using 31 days as a month, just do everything from now() to now() + (86400 x 31)

So what would the SQL statment be if `dateline_from`is my start date

SimonCHere · 25 Sep 2009 at 09:30

Does

Code:

SELECT * FROM `event` WHERE FROM_UNIXTIME( `dateline_from` , format)  between CURDATE() and DATE_ADD(CURDATE(), INTERVAL 1 MONTH);

Work?
You could replace CURDATE() with FROM_UNIXTIME( `dateline_from` , format)