Construct a SQL Query

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

Hi there!

I need help with constructing a sql query.

Currently the query is:

select ID, description, price, date from table where Datum >= DateAdd("n",-3,getdate())

Which returns

ID | Description | Price | Date

I also return how many days left, hours left , minutes left using datediff.

Like this:

ID | Description | Price | Date | DaysLeft | HoursLeft | MinutesLeft

This should be supereasy for someone with good SQL-knowledge.

Microsoft SQL Server

Project ID: #11912078

About the project

2 proposals Remote project Active 7 years ago

Awarded to:

$10 USD in 1 day
(0 Reviews)
0.0

2 freelancers are bidding on average $15 for this job

sanjayahlawat1

Sir, I can do this project .Message me to discuss. My goal is to provide best service for my clients in minimum possible amount. I will accept projects only when i'm 100% sure. Thanks! :)

$20 USD in 0 days
(4 Reviews)
2.3