you can store you dates like integers using time(). So you can use strftme
without any string operation.
[]'s
Victor
Lawrence Chitty <[EMAIL PROTECTED]> escreveu:
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
>
>
"Só existem 10 tipos de pessoas, as que sabem e as que não sabem binário."
---------------------------------
Yahoo! Acesso Grátis: Internet rápida e grátis. Instale o discador agora!
