This content has been marked as final. Show 3 replies
I'm stuck on a seemingly easy task. I load data from a table with a date column and want to filter the data to only load records from a specific year.
I've been trying alot of different variants as candidates for the WHERE clause, all with different errors.
start_time is the name of the column that hold the date.
SQL##f - SqlState: 42883, ErrorCode: 7, ErrorMsg: ERROR: function year(unknown) does not exist;
let start_date=MakeDate(2014, 01, 01);
ErrorCode: 7, ErrorMsg: ERROR: function year(integer) does not exist;
What am I doing wrong here?