0 votes
1 view
in SQL by (22.4k points)

I have a query to fetch date diff between 2 datetime as :

SELECT DATEDIFF(DAY, @CreatedDate , GETDATE())

Ex :

SELECT DATEDIFF(DAY, '2013-03-13 00:00:00.000' , GETDATE())

I need to have a query work like this which will subtract a day from the created day:

SELECT DATEDIFF(DAY, **@CreatedDate- 1** , GETDATE())

1 Answer

0 votes
by (40.3k points)

Try using the timedelta object like this:

from datetime import datetime, timedelta

d = datetime.today() - timedelta(days=days_to_subtract)

Related questions

0 votes
1 answer
asked Jul 9, 2019 in SQL by Tech4ever (22.4k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...