You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The expanded syntax for the newly-implemented built-in function is as follows:
DATEDIFF( <timestamp_part> FROM <date_time> FOR <date_time> )
Use of the prepositions FROM and FOR as keywords conveys the wrong semantics. The meaning should be expressed by a semantically correct pair of prepositions.
Suggested:
DATEDIFF( <timestamp_part> FROM <date_time> TO <date_time> )
or
DATEDIFF( <timestamp_part> BETWEEN <date_time> AND <date_time> )
A contracted alternative syntax is available, sans prepositions:
As a temporary measure, the Beta 2 release notes will include a warning that the keywords will change in Beta 3 and recommending use of the contracted syntax for the time being.
assignee: Adriano dos Santos Fernandes [ asfernandes ]
summary: New inbuilt function DATEDIFF() implements wrong choice of keywords for expanded syntax => New builtin function DATEDIFF() implements wrong choice of keywords for expanded syntax
Submitted by: @helebor
The expanded syntax for the newly-implemented built-in function is as follows:
DATEDIFF( <timestamp_part> FROM <date_time> FOR <date_time> )
Use of the prepositions FROM and FOR as keywords conveys the wrong semantics. The meaning should be expressed by a semantically correct pair of prepositions.
Suggested:
DATEDIFF( <timestamp_part> FROM <date_time> TO <date_time> )
or
DATEDIFF( <timestamp_part> BETWEEN <date_time> AND <date_time> )
A contracted alternative syntax is available, sans prepositions:
DATEDIFF( <timestamp_part>, <date_time>, <date_time> )
As a temporary measure, the Beta 2 release notes will include a warning that the keywords will change in Beta 3 and recommending use of the contracted syntax for the time being.
Commits: d8dde42
The text was updated successfully, but these errors were encountered: