cast(... as date) returns a timestamp instead of a date

[sanoso...@gmail.com]

Hi,

cast(... as date) returns usually a date, but on a particular notebook it returns a timestamp! I don't understand what's different about this notebook.

[Dimitry Sibiryakov]

15.04.2021 16:24, sanoso...@gmail.com wrote:
> cast(... as date) returns usually a date, but on a particular notebook it returns a
> timestamp! I don't understand what's different about this notebook.

Database or query with dialect 1.

--
WBR, SD.

[Mark Rotteveel]

You're either using a dialect 1 database, or you're connecting to a
dialect 3 database with dialect 1 as connection dialect. In dialect 1, a
DATE is actually a date+time (aka TIMESTAMP in dialect 3).

Mark
--
Mark Rotteveel

[sanoso...@gmail.com]

Someone changed the dialect in the odbc data source. Thanks!