#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    69
    Rep Power
    11

    Angry Date/Time Problem


    Hi Guys,

    I want to extract rows from a oracle table where data entry time is(field called entrytime) >= 00 hrs yesterday and entytime < 1200 hrs today

    How do I do this?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    11
    'and entytime < 1200 hrs today' is:

    where entytime > sysdate - (1/24 * 1200)

    Cheers,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo