java - 转换 SQLite 查询日期格式

Question

我的 SQLite 数据库表中有一个日期列，我以 YYYY-MM-DD 格式插入日期以便于排序，现在我尝试以 DD-MM-YYYY 格式排序后检索日期，不要知道怎么做。我可以只使用 SQLite 查询而不使用 PHP 或 Java 等显示语言来实现

Answer 1

https://sqlite.org/lang_datefunc.html

The strftime() routine returns the date formatted according to the format string specified as the first argument. The format string supports the most common substitutions found in the strftime() function from the standard C library plus two new substitutions, %f and %J. The following is a complete list of valid strftime() substitutions:

%d day of month: 00
%f fractional seconds: SS.SSS
%H hour: 00-24
%j day of year: 001-366
%J Julian day number
%m month: 01-12
%M minute: 00-59
%s seconds since 1970-01-01
%S seconds: 00-59
%w day of week 0-6 with Sunday==0
%W week of year: 00-53
%Y year: 0000-9999
%% %

-> SELECT strftime('%d-%m-%Y', 从 your_table 中选择日期)