Home/ Questions/Q 3787
Next
Answered

Oraask Latest Questions

Question
ayaali
  • 0
  • 0
Explorer
Asked: 2016-06-14T23:58:46+03:00 In:

get number of days between two dates column in oracle sql?

  • 0
  • 0

i have two date columns and i want to get the number of days between those two dates

columndateoraclesql
Share

    Related Questions

    2 Answers

    1. ashishpandey
      Explorer
      This answer was edited.

      Hi, Like this we can use:

      SELECT pol_fm_dt, pol_to_dt, ROUND(pol_to_dt - pol_fm_dt) FROM pgit_policy;

       

    2. Gomaa Elmokhtar
      Best Answer
      Explorer
      This answer was edited.

      we assume that first date is sysdate and second date  is  a column with name ‘hire_date ‘ then use this query

      select trunc(sysdate) -to_date(hire_date,'yyyy-mm-dd') from dual  .

       

    Leave an answer

    You must login to add an answer.

    Need An Account,