Hi Kees and John,
If you are getting data and storing it in an Sqlite database why not store it in the appropriate format?
I will be storing it in the appropriate format. That's the objective of this solution, to convert the data into the appropriate format. I just want to do it within SQL.
I would preprocess the data with an awk script. Perl or PHP or many other scripting tools are also suitable. Although it can be done, SQL just isn't the most elegant language to do these kind of things.
It may not be the most elegant, but it is the criteria of my question ;-) In this small project I currently have no need for any other scripting language, so don't want to introduce one when SQL does the job (however inelegant).
So, is there no better way to convert the date than the method I detailed?
Thanks, Tom ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
