How do I retrieve a datetime by specifying a year?

REST
1

While can retrieve a row using a specific date, how can I get all rows which contain a specific year in the datetime column?

image
image2154×660 69.3 KB

Thanks!

2

Hi Darrell,

If the data type of the weekDate column is DATETIME, then the where clause should look like this:

year( weekDay ) = 2020

Regards,
Mark

3

Yes!

That’s it. It’s all about they syntax. :+1: