Android Question Display date from query

[EdsonZanatta]

Friends, in my query sql server, field datetime returns: 2023-12-18 00:00:00.0 . I need to display in the format: 18/12/2023 (DD/MM/YYYY), date only, without the time, what better to this ?

 

[MicroDrie]

The short answer is both the date setting of the server and that of the client determine the solution. Ultimately you come to the question of how is the date stored in the SQL database? If that is textual, then you will have to make the solution to convert the given format into the format you want.

See also SQLite query date format or a broader search on SQL date