Re: [sqlite] formating yyyymmdd dates

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: mmdd >I want this format to be returned from a query:

Re: [sqlite] formating yyyymmdd dates

DuenosEnLaWEB.com.ar wrote: hi I have this format for dates: mmdd I want this format to be returned from a query: dd/mm/ 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)||=

[sqlite] formating yyyymmdd dates

hi I have this format for dates: mmdd I want this format to be returned from a query: dd/mm/ 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