Timeline for SQL query for next occurrence of specific date
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 2, 2014 at 12:32 | comment | added | ypercubeᵀᴹ | I found a way using some functions but I think it's more complicated (although it does not involve using any table.) | |
| May 2, 2014 at 12:25 | comment | added | sukach | @ypercube if you have a better idea, i'd love to hear it. the inner query merely returns a list of all months and using all_objects simply as a way of returning a specific number of rows. then, the outer query returns the first result of the inner query that is greater than the current date. | |
| May 2, 2014 at 0:33 | comment | added | ypercubeᵀᴹ |
I don't think you need all this complication. Why the use of all_objects?
|
|
| May 1, 2014 at 12:55 | history | answered | sukach | CC BY-SA 3.0 |