DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: sql

  1. #1
    Join Date
    May 2000
    Location
    maryland hights
    Posts
    20
    hi can someone give me a hint,
    i want to get the data from yeaterday 2 pm to today 3 pm.

    thanks
    Nallamothu

  2. #2
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    How about a hint of what columns are in the table to query against.

    Gary

  3. #3
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    SELECT *
    FROM my_table
    WHERE my_date_column BETWEEN (trunc(sysdate-1)+14/24) AND (trunc(sysdate)+15/24);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width