Is there a way I can create a view with last 7 days formated as DATE in mysql?
I have a query that I can use in where clause:
DATE_SUB( NOW(), INTERVAL 7 DAY )
but I can use it to create a standalone table.
Asked
Active
Viewed 160 times
0
-
Please provide more detail. Are you after a `VIEW` with 1 column that returns 7 rows of `date` values for the past 7 days? Or something else? – Dai Aug 28 '17 at 04:45
-
@Dai correct that is what I need – naneri Aug 28 '17 at 04:52
-
Yes. There is, and you can. Next! – Strawberry Aug 28 '17 at 06:44
-
@Strawberry can you prove that? – naneri Aug 28 '17 at 12:12