FUNGSI DATEDIFF() SERVER SQL
Definisi dan Penggunaan
FUNGSI DATEDIFF() DATEDIFF() mengembalikan waktu antara dua tanggal.
Syarat
DATEDIFF(datepart,startdate,enddate)
startdate dan enddate Parameter adalah ekspresi tanggal yang sah.
datepart Parameter dapat berupa nilai berikut:
| datepart | Abbreviation |
|---|---|
| Year | yy, yyyy |
| Quarter | qq, q |
| Month | mm, m |
| Day in the year | dy, y |
| Day | dd, d |
| Week | wk, ww |
| Week | dw, w |
| Hour | hh |
| Minute | mi, n |
| Second | ss, s |
| Millisecond | ms |
| Microsecond | mcs |
| Nanosecond | ns |
Contoh
Contoh 1
Gunakan pernyataan SELECT berikut:
SELECT DATEDIFF(day,'2008-12-29','2008-12-30') AS DiffDate
Hasil:
| DiffDate |
|---|
| 1 |
Contoh 2
Gunakan pernyataan SELECT berikut:
SELECT DATEDIFF(day,'2008-12-30','2008-12-29') AS DiffDate
Hasil:
| DiffDate |
|---|
| -1 |
