vmag Active Member Jun 3, 2020 #1 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...
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 Active Member Jun 3, 2020 #2 Thank you, problem solved! FORMAT([datem],'dd.mm.yyyy') AS D1 Upvote 0
