Re: Inconsistent behaviour adding to dates
Hi, > CURRENT_DATE+1 // works (adds one day) > ?+1 // where ? is set as a date > does not work > > Which seems to me to be inconsistent. In the first case, the database knows the data type when parsing, in the second case it can't possibly know, so i
Inconsistent behaviour adding to dates
Hi, I came across this issue. Essentially the problem seems to be that: CURRENT_DATE+1 // works (adds one day) ?+1 // where ? is set as a date does not work Which seems to me to be inconsistent. I realise that I should be using the dateadd/datediff