how i can calculate date difference in oracle[Answered] RSS

• • Reply
  rockyy

  Member

  60 Points

  189 Posts

  how i can calculate date difference in oracle

  Sep 01, 2010 07:47 AM|rockyy|LINK

  [IMG]http://i51.tinypic.com/33epso4.jpg[/IMG]

  
  

  how i can calculate the date diff in Oracle 10g using pl sql developer 7

  
  

  
  

  thank you
  

• • Reply
  vik20000in

  All-Star

  17775 Points

  3957 Posts

  Re: how i can calculate date difference in oracle

  Sep 01, 2010 08:03 AM|vik20000in|LINK

  check this blog

  http://plsql.globinch.com/2008/11/13/oracle-date-difference-date-difference-in-sql-and-plsql/ 

  Vikram
  www.vikramlakhotia.com
  
  
  Please mark the answer if it helped you
• • Reply
  rockyy

  Member

  60 Points

  189 Posts

  Re: how i can calculate date difference in oracle

  Sep 01, 2010 08:22 AM|rockyy|LINK

   i did this but this is not a right solution

  select recievebydeo-sendbydeo,
  receivebyregistrar-sendbyregistar,
  recivetimesubregistrar-sendtimesubregistrar
   from user2

  
  please guide me to a better solution
  

  
  

• • Reply
  Lannie

  Contributor

  3422 Points

  1335 Posts

  how i can calculate date difference in oracle

  Sep 08, 2010 07:38 PM|Lannie|LINK

  try

  select 

    date_recieveby - date_sendto AS days_between_send_receive

  from user2;

   

  assumes of course that date_receiveby and date_sendto are DATE datatypes...

  if they are text, you have to convert to DATE datatype before doing date math,

  using oracle TO_DATE(string_date, '{formatstring]') function.