PURE SQL get days beteen given date and current date, without functions

Question

I need to get number of days between 2 dates, a given one and current date.

But in pure SQL, I mean without usign functions, it is possible?

For exaple

SELECT days (t.givenDate) - days (current date) FROM table t

Have you any idea?

Thaks a lot.

You mean like this? SELECT DATEDIFF(DAY, current_date(), t.givenDate) FROM dbo.Table t — Csanchez, Sep 28 '18 at 20:13
yes, note - your syntax is ms sql server, mysql's function does not have 1st argument — Iłya Bursov, Sep 28 '18 at 20:15
You're right it works like this: SELECT DATEDIFF (current_date(), t.givenDate) FROM dbo.Table t. Thanks a lot — Csanchez, Sep 28 '18 at 20:17
mysql syntax does not work in ms sql server, what dbo you're using? — Iłya Bursov, Sep 28 '18 at 20:18

score 1 · Accepted Answer · answered Sep 28 '18 at 20:39

1

The built-in function is datediff(). The equivalent for the above is:

SELECT datediff(t.givenDate, curdate()) FROM table t;

Normally, givenDate would be in the past and you would want the arguments in the other order.

answered Sep 28 '18 at 20:39

Gordon Linoff

1 Answers1