Number of days between two given dates

Question

How do I calculate number of days between the to dates strictly using HQL alone.

supposing Current_Date and Expiry_Date are two dates fetched from database. I want to calculate days between Current_Date and Expiry_Date.

Also, How will I handle, if any of the value is null ?

try to see http://stackoverflow.com/questions/4759248/difference-between-two-dates-in-mysql — user1692333, Mar 14 '13 at 07:33

score 2 · Answer 1 · answered Mar 14 '13 at 07:34

2

DECLARE @startdate datetime2 = '2013-12-05 12:10:09.3312722';
DECLARE @enddate datetime2 = '2013-12-04 12:10:09.3312722'; 
SELECT DATEDIFF(day, isnull(@startdate,GetDate()), isnull(@enddate,GetDate()));

answered Mar 14 '13 at 07:34

Pranay Rana

175,020
35
237
263

score 0 · Accepted Answer · edited Feb 26 '18 at 13:59

0

I figured an solution for my issue.

(extract(doy from bp.qhrIqamaexpirDate)-extract(doy from now()))

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

edited Feb 26 '18 at 13:59

Paolo Forgia

6,572
8
46
58

answered Mar 14 '13 at 09:26

Gopinagh.R

4,826
4
44
60

Number of days between two given dates

2 Answers2

Linked