check date oracle RSS

• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  check date oracle

  Aug 30, 2012 10:23 AM|LINK

  I would like to aske about how can i filter the record that the date is between 3-sep-2012 to 9-sep -2012 the db has the start and end date if the start day is 1-sep and end day is 11-sep how can i check the days is inside day range .next week based on db record by using package oracle
• • Reply
  

  Ajay2707

  Contributor

  4483 Points

  868 Posts

  Re: check date oracle

  Aug 30, 2012 11:34 AM|LINK

  Hi,

  see this,

  http://www.dba-oracle.com/t_sql_compare_two_date_ranges.htm

  http://www.demiliani.com/blog/archive/2006/01/19/3384.aspx

  Please, Mark as Answer if this reply helped you.
• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  Re: check date oracle

  Aug 30, 2012 02:42 PM|LINK

  Ajay2707

  Hi,

  see this,

  http://www.dba-oracle.com/t_sql_compare_two_date_ranges.htm

  http://www.demiliani.com/blog/archive/2006/01/19/3384.aspx

   i would like to ask if overlaps function that doesn't include the date on that date record

  for example

  select * from dual where (to_date(01-09-2012,'dd-mm-yyyy'),to_date('11-09-2012','dd-mm-yyyy')) overlaps

   (to_date(03-09-2012,'dd-mm-yyyy'),to_date('09-09-2012','dd-mm-yyyy'))

  if the record start on 3-sep-2012,that doesn't include ???

   

  • Edited by -_- on Aug 31, 2012 01:33 AM
  • Edited by -_- on Aug 31, 2012 02:11 AM
• • Reply
  

  Ajay2707

  Contributor

  4483 Points

  868 Posts

  Re: check date oracle

  Sep 04, 2012 04:33 AM|LINK

  Hi Memeber,

  It is not good to overlaps date. See below link with example.

  http://www.orafaq.com/node/2067

  https://forums.oracle.com/forums/thread.jspa?messageID=10388865

  Please, Mark as Answer if this reply helped you.
  • Marked as answer by Young Yang - MSFT on Sep 10, 2012 09:17 AM