Last post Aug 27, 2018 04:39 AM by vahid bakkhi
Member
49 Points
154 Posts
Aug 26, 2018 02:55 PM|chnar|LINK
i have this table
id date
1 2010-08-26
2 2010-08-24
3 2010-08-23
i want to that date column where date ago=3 in sql
i wrote this code but not working fine
SELECT date from tb where date> DATEADD(day, -3 SYSDATETIME())
All-Star
50854 Points
12100 Posts
Aug 26, 2018 05:04 PM|bruce (sqlwork.com)|LINK
you need to to get the date only:
SELECT date from tb where date > DATEADD(day, -3, CONVERT(date, GETDATE()))
52202 Points
15507 Posts
Aug 27, 2018 01:22 AM|oned_gk|LINK
Use brackets for date word SELECT [Date] ...
SELECT [date] from tb where date < CAST(DATEADD(day, -3,GetDate()) as Date)
GetDate() get current datetime
CAST as Date to remove time part
Star
8069 Points
2780 Posts
Aug 27, 2018 04:39 AM|vahid bakkhi|LINK
hi
you can use DATEDIFF function for find different date between 2 fields , please try below query
SELECT [date] from tb where DATEDIFF(DAY,[date], getdate()) >= 3
Member
49 Points
154 Posts
get date before three days ago
Aug 26, 2018 02:55 PM|chnar|LINK
i have this table
id date
1 2010-08-26
2 2010-08-24
3 2010-08-23
i want to that date column where date ago=3 in sql
i wrote this code but not working fine
SELECT date from tb where date> DATEADD(day, -3 SYSDATETIME())
All-Star
50854 Points
12100 Posts
Re: get date before three days ago
Aug 26, 2018 05:04 PM|bruce (sqlwork.com)|LINK
you need to to get the date only:
All-Star
52202 Points
15507 Posts
Re: get date before three days ago
Aug 27, 2018 01:22 AM|oned_gk|LINK
Use brackets for date word SELECT [Date] ...
GetDate() get current datetime
CAST as Date to remove time part
Suwandi - Non Graduate Programmer
Star
8069 Points
2780 Posts
Re: get date before three days ago
Aug 27, 2018 04:39 AM|vahid bakkhi|LINK
hi
you can use DATEDIFF function for find different date between 2 fields , please try below query
Please MARK AS ANSWER if suggestion helps.