List of datetime array using Oracle

The original problematic line :

 SELECT p_from_date + level - 1 dt FROM
       (
       SELECT to_date('1980-11-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AS p_from_date,
       to_date( '1980-11-03 00:00:00','yyyy-mm-dd hh24:mi:ss') AS p_to_date
       FROM dual
       )
     CONNECT BY level <= p_to_date - p_from_date

result :

DT
-------------------------
1980-11-01 00:00:00
1980-11-02 00:00:00

the fix :

 SELECT p_from_date + level/24 dt FROM
       (
       SELECT to_date('1980-11-01 01:00:00','yyyy-mm-dd hh24:mi:ss') AS p_from_date,
       to_date( '1980-11-03 09:00:00','yyyy-mm-dd hh24:mi:ss') AS p_to_date
       FROM dual
       )
     CONNECT BY level/24 <= p_to_date - p_from_date

result :

DT
-------------------------
1980-11-01 02:00:00
1980-11-01 03:00:00
1980-11-01 04:00:00
1980-11-01 05:00:00
1980-11-01 06:00:00
1980-11-01 07:00:00
1980-11-01 08:00:00
1980-11-01 09:00:00
1980-11-01 10:00:00
1980-11-01 11:00:00
1980-11-01 12:00:00
1980-11-01 13:00:00
1980-11-01 14:00:00
1980-11-01 15:00:00
1980-11-01 16:00:00
1980-11-01 17:00:00
1980-11-01 18:00:00
1980-11-01 19:00:00
1980-11-01 20:00:00
1980-11-01 21:00:00
1980-11-01 22:00:00
1980-11-01 23:00:00
1980-11-02 00:00:00
1980-11-02 01:00:00
1980-11-02 02:00:00
1980-11-02 03:00:00
1980-11-02 04:00:00
1980-11-02 05:00:00
1980-11-02 06:00:00
1980-11-02 07:00:00
1980-11-02 08:00:00
1980-11-02 09:00:00
1980-11-02 10:00:00
1980-11-02 11:00:00
1980-11-02 12:00:00
1980-11-02 13:00:00
1980-11-02 14:00:00
1980-11-02 15:00:00
1980-11-02 16:00:00
1980-11-02 17:00:00
1980-11-02 18:00:00
1980-11-02 19:00:00
1980-11-02 20:00:00
1980-11-02 21:00:00
1980-11-02 22:00:00
1980-11-02 23:00:00
1980-11-03 00:00:00
1980-11-03 01:00:00
1980-11-03 02:00:00
1980-11-03 03:00:00
1980-11-03 04:00:00
1980-11-03 05:00:00
1980-11-03 06:00:00
1980-11-03 07:00:00
1980-11-03 08:00:00
1980-11-03 09:00:00
 
 56 rows selected

p/s : now, am applying self-restraint not to jump onto our customer..

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Like

Related Post

6 Responses

  1. dotsha says:

    The problem is:

    1) Most aunty and uncle types will never know how to log into their router and disable it. Not entirely a big problem as they are okay with the default settings, BUT …

    2) … At that time, TM set a standard “admin123” (not exact word) password, i.e. standard easy-to-guess password on all router.

    So the big hoo haa is not that TM can remote admin your router, the big hoo haa is that someone else can remote admin your router.

    For router, the impact is not so significant, worse case they can get into your personal data and copy out.

    But let’s say similar situation exists with the phone VOIP/SIP setup. So if someone “borrows” your account and makes IDD calls … and billed to you, you would not be quiet …

    Reply
  2. dotsha says:

    ALSO … it turned out later that whether the password is standard and simple, or unique and complicated makes no difference.

    There’s a bug in the firmware of that router that lets someone remotely download the settings without having to provide an administrator id and password! 😎

    Reply
  3. namran says:

    haha.. that’s make sense to either replace this DLink DIR-615 or change it to support use custom router instead.

    However , TM had disabled it from the menu by now.
    plain locked up ? was thinking is it worth to re-flash with original firmware or not just because some script inside /www/bsc_wan.php got commented out?

    Reply
  4. dotsha says:

    I think original dlink firmware doesn’t have the pppoe over vlan support. this I’ve custom done for tm.

    And so far if you flash it with dd-wrt, tv stops working.

    the other way is to set it to bridged mode + vlan tagging, and use back your old router. or is that the option tm disabled?

    Reply
  5. dotsha says:

    I think original dlink firmware doesn’t have the pppoe over vlan support. this is custom done for tm.

    And so far if you flash it with dd-wrt, tv stops working.

    the other way is to set it to bridged mode + vlan tagging, and use back your old router. or is that the option tm disabled?

    Reply
  6. WeeMeng says:

    Anyone can let me know what is the user and password to login to my Dlink .

    and would like to know anyone have try to set up wifi router ? ( i am thinking to use my 3Com router instead of this DLink )

    Thanks
    WM

    Reply

Anything to add?

X