Yugax Krrish
Reputation: 1
I am trying fetch the first 6 month record data from a table based on the creation Date and activity_day from source table
activity_day >= creation_date + interval 6 month
Not getting any data
Upvotes: 0
Views: 13
Answers (1)
sankar
Reputation: 340
If you are checking for first 6 months records with respect to creation_date, then you need to use between logic like activity_day >= creation_date and activity_day <= creation_date + interval 6 month
Upvotes: 1
Related Questions
- Scala dataframe get last 6 months latest data
- How to get First date of month in Spark SQL?
- How to get date of first day three months ago from a date in sql?
- Computing First Day of Previous Quarter in Spark SQL
- Comparing Dates by Day and Month in Spark SQL
- Pull monthly data using Spark Scala
- How to pull data by looping over dates in pyspark sql?
- To get Date Series from Start and end date in Spark SQL
- Spark dataset to_date/year function
- Populating SQL Table values based a condition and a date range