• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# deq()

Read（2393） Label: two date values, equal,

Description:

Compare the specified two dates.

Syntax:

deq(datetimeExp1,datetimeExp2)

Note:

The function compares two date parameters - dateExp1 and dateExp2 - to see if they are equal. By default, the result is accurate to day.

Parameter:

 datetimeExp1/datetimeExp2 Date or standard datetime format string such as yyyy-MM-dd HH:mm:ss, yyyy-MM-dd, or HH:mm:ss

Option:

 @y Accurate to the year @q Accurate to the quarter @m Accurate to the month @t Accurate to the ten-day period @w Accurate to the week; take Sunday as the first day of the week @1 Work with @w option and take Mondy as the first day of the week; it is number 1 that is used in the option

Return value:

Boolean value

Example:

 A 1 =deq("1988-12-08","1988-12-07") false; judge whether two dates are equal. 2 =deq@y(date("1988-11-08"),date("1988-09-12")) true; judge whether two dates belong to the same year. 3 =deq@m(date("1988-11-08"),date("1988-09-12")) false; judge whether two dates belong to the same month. 4 =deq@q(date("1988-12-08"),date("1988-10-12")) true; judge whether two dates belong to the same quarter. 5 =deq@t(date("1988-10-08"),date("1988-10-12")) false; judge whether two dates belong to the same 10-day period of a month. 6 =deq@w(date("2023-09-03"),date("2023-09-09")) true; take Sunday as the first day of a week and judge whether two dates belong to the same week. 7 =deq@1w(date("2023-09-03"),date("2023-09-09")) false; take Monday as the first day of a week and judge whether two dates belong to the same week.