更新时间:2022-06-05 22:34:44
我为我的问题找到了解决方案。
I figured an solution for my issue.
(extract(doy from bp.qhrIqamaexpirDate)-extract(doy from now()))
doy
表示一年中的某一天(1-365/366)。
doy
represents The day of the year (1 - 365/366).
bp.qhrIqamaexpirDate : 2013-02-28 00:00:00.0
now() : 2013-03-14 14:53:12.051562
extract(doy from bp.qhrIqamaexpirDate) : 59, extract(doy from now()) : 73