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.
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 |
|
|
Accurate to the day by default |
Return value:
A boolean value
Example:
|
deq("1988-12-08","1988-12-07") |
false |
|
deq@y(date("1988-11-08"),date("1988-09-12")) |
true |
|
deq@m(date("1988-11-08"),date("1988-09-12")) |
false |
|
deq@q(date("1988-12-08"),date("1988-10-12")) |
true |
|
deq@t(date("1988-10-08"),date("1988-10-12")) |
false |
|
deq@w(date("1988-10-05"),date("1988-10-08")) |
true |