Filtering Time range in SQL Query

[OscarLucas]

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.

[JordanCClark]

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

[Andrii.Randiuk]

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}’)

[OscarLucas]

Thanks