B4J Question B4J and SQL

[vmag]

Hello!
- I work with UCanAccess(ucanaccess-5.0.0.jar) + B4J(8.30)
- in the query, when selecting date fields, the following values are obtained: 2020-05-29 00:00:00.0000
- can such values be converted immediately to 29.05.2020 in the request itself ?
Now you have to do the conversion at an intermediate stage (between the selection and the record in Tableview)
You can't change the structure of fields in the database.
Thanks...

 

[vmag]

Thank you, problem solved!
FORMAT([datem],'dd.mm.yyyy') AS D1