date difference getdate () - yyyy-mm-dd

Question

My table has an date column 'orderdate' with type as yyyy-mm-dd I want to get the date difference against getdate()

select getdate() - orderdate from table

this should return the number of days

Read up about `datediff()`. Note - I am a different Raj :) – Raj Sep 25 '14 at 06:50 — Raj, Sep 25 '14 at 06:50

score 2 · Accepted Answer · answered Sep 25 '14 at 06:54

2

You Need to use this:

SELECT DATEDIFF(DAY,orderdate,GETDATE()) FROM table

answered Sep 25 '14 at 06:54

ADP_X

1 Answers1