Hello, I am using SQLite as part of Trac (http://trac.edgewall.com/) to generate reports on our ticket system.
I have normal date fields (stored as an integer, and easily manipulated with date(), strftime(), etc.) I have one extra field that contains a date but is stored as a DD/MM/YYYY string. I would like to calculate the number of days between the two. This would be an easy juliandate() substraction if both dates were of the same data type, but they aren't. I am looking for a function similar to Oracle's TO_DATE(string,'DD/MM/YYYY') which would convert my string into a numerical value representing that date. This would then allow me to use normal date functions to work on it. I have tried TO_DATE in SQLite but it didn't work. Is there an equivalent function? If not, is there any other way to achieve what I'm trying to do? Thanks in advance for your insights. Regards ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------