var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DATE_SUB(WEEK) specifying date mode
Really simple question I want to change the date mode but cannot figure out how to do it while using date_sub. I know the below is wrong, so how do I do it?
WHERE WEEK(meetings.date,1) = DATE_SUB(WEEK(CURDATE(),1,INTERVAL 1 WEEK))
Date_Sub() is not a SQL Server function.
Perhaps you are using MySQL?
The equivalent in SQL Server is DateAdd() [but using negative numbers]
Ahh sorry I have posted in the wrong forum! Yes I am using MySQL, thanks I will pop it over there