Jump to content


This topic is now archived and is closed to further replies.


MSSQL - Query Last 30 Days

Recommended Posts


The following code worked fine in Mysql (Note: Already changed mysql to mssql).  It queries a table for songs added in the last 30 days (today - 30).

$dayspast = 30;
$result = mssql_query("
SELECT date_added, artist, title, album
FROM songlist
WHERE (songtype='S')
AND date_added > (SUBDATE(NOW(),INTERVAL '".$dayspast."' DAY))
ORDER BY date_added DESC, artist,title,album", $sqlconnect);[/i]

I am getting an error saying NOW is not a recognized function name.

Can someone help me code this correctly for a MS SQL DB?

It would be GREATLY appreciated.



Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.