+ 1
I want to filter on data using where clause on column startdate earlier than 10 months ago from March 2021
How should I write where clause which satisfy above condition please help..šš¼.
7 Answers
+ 1
What did you try and why do you think it should work? What are your observations and why do you think it didn't work?
+ 1
Aditya It's difficult to say without seeing the database and data types. Also the intervall you tried looks weird. Both of them are lower bound without upper limit.
Try this.
https://stackoverflow.com/questions/65841023/sql-between-date-range-on-string-date
+ 1
Aditya Sorry, I don't have time and I can't use that without an account (I don't create accounts I don't need). The link I shared should solve your problem.
0
Hi Mustafa A I tried this where filter but it doesn't seems to work
Where signup_start_date >= '2020-05-01'
and
signup_start_date >= '2021-02-28'
Please help me out on it..
0
platform.stratascratch.com/coding/2031-transactions-by-billing-method-and-signup-id?python=
Link to the question
0
Mustafa A here is database and question please help me out if you got any free time
https://platform.stratascratch.com/coding/2031-transactions-by-billing-method-and-signup-id?JUMP_LINK__&&__python__&&__JUMP_LINK=
0
Thanks Mustafa A