On Mar 17, 2005, at 4:27 PM, Kurt Welgehausen wrote:
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
I do think that it's more expressive than 6,2, but not than "substr(d,1,10)||' '||substr(d,-8,8)".
Regards,
David
