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