Can You tell a dif­fe­ren­ce between

SELECT *, format(Data_ur, "yyyy-mm-dd") AS Datur FROM Czlonkowie

and

SELECT *, format(Data_ur, 'yyyy-mm-dd') AS Datur FROM Czlonkowie

?

It turns out that when using ODBC to con­nect to Micro­soft Access data­ba­se (in an mdb file), one has to use sin­gle quotes when wri­ting func­tion para­me­ters. The first sta­te­ment runs fine from the Access itself, but when cal­led thro­ugh the ODBC (for instan­ce when using PHP and PDO) it returns emp­ty set (it doesn’t even throw an exception).

The second sta­te­ment (with sin­gle quotes) runs fine thro­ugh ODBC. Worth remembering.