DuenosEnLaWEB.com.ar wrote:
hi
I have this format for dates: yyyymmdd
I want this format to be returned from a query: dd/mm/yyyy
The only way i have found is doing this... but i do not like it very =
much
SELECT =
strftime('%d/%m/%Y',substr('20050605',1,4)||'-'||substr('20050605',5,2)||=
'-'||substr('20050605',7,2));
is there a better way to get it?
Why not just
SELECT
substr('20050605',7,2)||'/'||substr('20050605',5,2)||'/'||substr('20050605',1,4)
Lawrence
thanks
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/86 - Release Date: 31/08/2005