Parse error: syntax error, unexpected T_LNUMBER

Question

i have this error: "Parse error: syntax error, unexpected T_LNUMBER in line 14 " i would like to calculate difference between two dates

function datedifference()
{
   $res=dbconnect()->exec("SELECT DATEDIFF("2017-06-25", "2017-06-15");");

   echo $res;
}

use single quotes for dates – Agnius Vasiliauskas Dec 14 '17 at 07:33 — Agnius Vasiliauskas, Dec 14 '17 at 07:33

score 1 · Answer 1 · answered Dec 14 '17 at 07:34

1

The problem is that your string syntax is wrong, you have not escaped the " quotes inside the string, you can either use ' single-quote or escape the double quote:

Single-quote:

$res = dbconnect()->exec("SELECT DATEDIFF('2017-06-25', '2017-06-15');");

Escaped double quote:

$res = dbconnect()->exec("SELECT DATEDIFF(\"2017-06-25\", \"2017-06-15\");");

answered Dec 14 '17 at 07:34

mega6382

9,211
17
48
69

Please, be sure to accept the answer by clicking the grey tick under the voting buttons. – mega6382 Dec 14 '17 at 08:13

Parse error: syntax error, unexpected T_LNUMBER

1 Answers1