> Well, I might as well use the substr() function, then ... Yes, unless you think %m is more expressive than 6,2 or you want to extract more than one component.
sqlite> select * from datetest;
k d
---------- -------------------
1 2005-03-17T16:21:30
2 2005-03-17T17:22:30
sqlite> select strftime('On %m/%d at %H:%M', dd) Arrival_time from
...> (select substr(d,1,10)||' '||substr(d,-8,8) dd from datetest) ;
Arrival_time
-----------------
On 03/17 at 16:21
On 03/17 at 17:22
Regards
