Select one month from vwMonthData

Topics: 1. General
Sep 24, 2014 at 10:33 AM
I'm working with SBFspot 3.0.1
Can somebody help me with a query to select al the DayYield's from vwMonthData of one month. For the example we can use august 2014.
I come not further then "SELECT * FROM vwMonthData".
Thanks in advance.
Sep 24, 2014 at 11:29 AM
Edited Sep 24, 2014 at 3:05 PM
SELECT * FROM [vwMonthData]
WHERE strftime("%Y%m", [TimeStamp])="201408"
ORDER BY [Timestamp];
See SQL As Understood By SQLite
Marked as answer by SBF on 9/24/2014 at 4:29 AM
Sep 24, 2014 at 3:33 PM
Thank you.
Also for your "See"-tip. I can work this out now.