Results 1 to 3 of 3

Thread: [RESOLVED] How do I do this in SQL Server?

  1. May 1st, 2007, 04:05 AM #1
    Guru
    Guru is offline

    Thread Starter
    Addicted Member Guru's Avatar
    Join Date
    May 2000
    Location
    sulking in the cupboard under the stairs
    Posts
    237

    Resolved [RESOLVED] How do I do this in SQL Server?

    If I had a table in ACCESS with a date/time column and I wanted all records within the last 24 hours I could do this sort of thing:
    SELECT * FROM Table1 where datediff('n',Field1,now) < 1440

    How do I do this in SQL Server?




    Thanks
    Last edited by Hack; May 1st, 2007 at 06:11 AM. Reason: Added RESOLVED to thread title and green resolved checkmark
    Another light-hearted post from Guru
    Reply With Quote Reply With Quote
  2. May 1st, 2007, 04:33 AM #2
    The_Duck
    The_Duck is offline
    Hyperactive Member The_Duck's Avatar
    Join Date
    May 2005
    Location
    Leamington, UK
    Posts
    351

    Re: How do I do this in SQL Server?

    Give this a whirl!

    Code:
    SELECT * FROM Table1 where datediff(hour,Field1,GetDate()) <= 24
    Reply With Quote Reply With Quote
  3. May 1st, 2007, 04:42 AM #3
    Guru
    Guru is offline

    Thread Starter
    Addicted Member Guru's Avatar
    Join Date
    May 2000
    Location
    sulking in the cupboard under the stairs
    Posts
    237

    Re: How do I do this in SQL Server?

    Thanks
    That's perfect!
    Another light-hearted post from Guru
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width