• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

sql server - select a value from specific date

Hi

Im wanting to do a select query that selects a value from a table where its created date is in the last 72 hours.

Thanks
0
razza_b
Asked:
razza_b
1 Solution
 
virtuadeptCommented:
SELECT col1, col2, col3...
FROM table
WHERE create_date_column >= DATEADD(HOUR,-72,getdate())

Could be more helpful if you post the table definition.
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now