#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Memphis
    Posts
    12
    Rep Power
    0

    Retrieving last 12, last 24 hrs records


    Hi there !!
    I am new on this block. Can anyone help me to make an sql query which can retrive the last 12 hrs and the last 24 hrs record records.

    I didn't able to make the logic. I am using MS SQL Server2000 and ASP.

    With Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Cincinnati, OH USA
    Posts
    111
    Rep Power
    11
    Are you storing a date/time added in your database upon insert?

IMN logo majestic logo threadwatch logo seochat tools logo