Tuesday, October 27, 2015

Kira bilangan hari dari tarikh dalam SQL - Oracle

on   in   with 6 comments
select trunc(to_date(to_char(tarikh_tamat, 'yyyy-mm-dd'), 'yyyy-mm-dd') - to_date(to_char(tarikh_mula, 'yyyy-mm-dd'), 'yyyy-mm-dd')) + 1 as days from...
Share:

6 comments:

  1. rozieDecember 21, 2015 at 11:56 PM

    maini kasi la full sql dia....:D

    ReplyDelete
  2. MarkFebruary 6, 2016 at 6:47 PM

    t726jt http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com

    ReplyDelete
  3. MarkFebruary 6, 2016 at 10:00 PM

    q3lNU1 http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com

    ReplyDelete
  4. MarkFebruary 9, 2016 at 11:45 AM

    qr26FE http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com

    ReplyDelete
  5. MarkFebruary 10, 2016 at 10:38 PM

    7GdMNF http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com

    ReplyDelete
  6. MarkFebruary 11, 2016 at 10:28 AM

    ntuatK http://www.FyLitCl7Pf7kjQdDUOLQOuaxTXbj5iNG.com

    ReplyDelete