I was struggling for about 30 mins trying to get posts from the mySQL databases using ASP, basically due to the way threads stores the last post time in seconds.
Heres the code that eventually did it. I asked for posts with a last post date greater than this
DATEDIFF("s", "01/01/1970", DATEADD("s", 7*86400, NOW()))
The 7 is the number of days.
Anyway thought id share this to save anyone else struggling.