Filtering Time range in SQL Query

Hello
I would like to filter the data in a period of time.



I suppose that the failure is coming from the dateFormat i try
dateFormat(toDate( "2003-9-14 8:00:00" ), "yyyy-MM-dd 00:00:00" )
but it dosent work.

The ORDER BY clause needs to come after the WHERE clause.

2 Likes

SELECT * FROM yourtable
(Timestamp Between ‘{Root Container.Period Mode.Start Date.Start Date Calendar.date}’ AND ‘{Root Container.Period Mode.End Date.End Date Calendar.date}’)

Thanks