Construct a SQL Query

Selesai Dipasang 7 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

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

ID Proyek: #11912078

Tentang proyek

2 proposal Proyek online Aktif 7 tahun yang lalu

Diberikan kepada:

$10 USD dalam 1 hari
(0 Ulasan)
0.0

2 freelancer rata-rata menawar $15 untuk pekerjaan ini

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 dalam 0 hari
(4 Ulasan)
2.3