DateTime SQL

How to get time in SQL query, I need a time 24 hrs from now.
karthikramAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
select dateadd(day, -1, getdate())
0
 
mastooCommented:
select DateAdd( hh, 24, GetDate() )
0
 
Brian CroweDatabase AdministratorCommented:
SELECT DATEADD(day, 1, GetDate())
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>24 hrs from now.
My suggestion is 24 hours (1 day) before now... sorry
0
 
karthikramAuthor Commented:
I need for 24 hours before .
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well, then my first suggest was correct ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.