CODEWITHSUNDEEP
sqloracle-databasedate
JHegde
JHegde

Reputation: 41

ORACLE SQL- Number of Days between 2 dates

I need help with getting the number of days between 2 dates in ORACLE SQL. If the HOSP_DISCH_TIME and HOSP_ADMSN_TIME are on the same day then it should return 0(zero). The dates are in 09-MAY-11 (DD-MMM-YY) format.

Here is my code - 

 select HOSP_DISCH_TIME, HOSP_ADMSN_TIME, (HOSP_DISCH_TIME- 
 HOSP_ADMSN_TIME)as 
 Days 
 from PAT_ENC_HSP;

Thanks much! JH

Upvotes: 0

Views: 90

Answers (2)

OmarInCS
OmarInCS

Reputation: 97

select HOSP_DISCH_TIME, HOSP_ADMSN_TIME,
       trunc(HOSP_DISCH_TIME - HOSP_ADMSN_TIME) as Days 
from PAT_ENC_HSP;

Upvotes: 1

Zaynul Abadin Tuhin
Zaynul Abadin Tuhin

Reputation: 32011

convert it on date format and subtract

 select HOSP_DISCH_TIME, HOSP_ADMSN_TIME, TO_DATE(HOSP_DISCH_TIME, 'YYYY-MM-DD') -  
           TO_DATE(HOSP_ADMSN_TIME, 'YYYY-MM-DD') as  Days 
 from PAT_ENC_HSP;

Upvotes: 0

Related Questions