This project has moved and is read-only. For the latest updates, please go here.

Select one month from vwMonthData

Topics: 1. General
Sep 24, 2014 at 11: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.
/Frans
Sep 24, 2014 at 12:29 PM
Edited Sep 24, 2014 at 4: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 4:33 PM
Thank you.
Also for your "See"-tip. I can work this out now.