SQL Date_Sub syntax error

Question

I have been looking at this statement for ages and simply cannot find the error can you guys help?

        SELECT XD.*, UhED.row_class,
            (SELECT id
                FROM Comment C
                WHERE C.Excel_Data_Excel_Lists_id = XD.Excel_Lists_id
                    AND C.Excel_Data_row = XD.row
                LIMIT 1
            ) AS has_activity
        FROM User_has_Excel_Lists UhXL
        JOIN Excel_Lists XL
            ON XL.id = UhXL.Excel_Lists_id
        JOIN Excel_Data XD
            ON XD.Excel_Lists_id = XL.id
        LEFT JOIN User_has_Excel_Data UhED
            ON UhED.Excel_Data_Excel_Lists_id = XL.id
                AND UhED.Excel_Data_row = XD.row
                AND UhED.User_id = 1
        WHERE UhXL.User_id = 1
            AND XL.created > DATE_SUB(DATE(now()), INTERVAL 2)<-- it says that the error is here
        GROUP BY XD.telephone 
        ORDER BY last_name ASC, first_name ASC

you should mention the day or month or year..DATE_SUB(DATE(now()), INTERVAL 2) — jmail
– jmail, Commented Mar 25, 2014 at 9:42

Divyam shukla · Accepted Answer · 2014-03-25 09:37:23Z

1

 AND XL.created > DATE_SUB(DATE(now()), INTERVAL 2 DAY)

try this it may help you

answered Mar 25, 2014 at 9:37

Divyam shukla

2,04614 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Klemen Tusar · Accepted Answer · 2014-03-25 09:36:47Z

1

You forgot do specify the interval unit maybe? Something like INTERVAL 2 DAY or INTERVAL 2 HOUR maybe?

answered Mar 25, 2014 at 9:36

Klemen Tusar

9,7494 gold badges36 silver badges28 bronze badges

Comments

Alexander · Accepted Answer · 2014-03-25 10:12:30Z

0

You may need to specify the measure for the interval (e.g., days, months, etc.)

You can check the syntax for DATE_SUB here

edited Mar 25, 2014 at 10:12

Alexander

3,1992 gold badges21 silver badges34 bronze badges

answered Mar 25, 2014 at 9:37

vicsana1

3691 silver badge4 bronze badges

Comments

jmail · Accepted Answer · 2014-03-25 10:13:18Z

0

if i understand your problem like follow this instructions as: you should must mention the day, month, hour, or year in the following line:

your code:

 AND XL.created > DATE_SUB(DATE(now()), INTERVAL 2)

change code: DAY

AND XL.created > DATE_SUB(DATE(now()), INTERVAL 2 DAY)

if you are using the DATE(tablename) in your table you getting error like:

WRONG CODE (sample)(http://sqlfiddle.com/#!2/5b7e2/7):check the code no:5

SELECT id,DATE_SUB(DAT(NOW()), INTERVAL 2 DAY) 
FROM supportContacts;

RIGHT CODE:

SELECT id,DATE_SUB(DATE(NOW()), INTERVAL 2 DAY) 
FROM supportContacts;

REFER THIS LINK: http://sqlfiddle.com/#!2/5b7e2/7

answered Mar 25, 2014 at 10:13

jmail

6,1503 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

SQL Date_Sub syntax error

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related