Dear All,<div><br></div><div>I am new to MonetDB, so most likely my question will look obvious.</div><div><br></div><div>I would like to ask, how can columns with date type is queried in monetdb.</div><div>Based on my experience, it seems that date type columns need special treatment. It seems that the only way to query them is with the syntax &quot;column_name&quot; while other columns seems to work with the format table_name.column_name without the need of double quote. When I tried to query date column with the syntax table_name.column_name, it gave me an error &quot;no such column&quot;</div>

<div><br></div><div>So my question is, is it true that the only way to query date columns is using &quot;column_name&quot; format? Another question will be, what happen if I need to query same name columns coming from different table?</div>

<div><br></div><div>Thanks in advance,</div><div>Freddy</div><div><br></div>