Support Topics Documentation Slack YouTube Blog

How do I retrieve a datetime by specifying a year?

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

Thanks!

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

Yes!

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