Yes, it looks it isn't there. It is no problem though to update the table and 25000 records takes about a third of a second when I do it from the integer yyyymmdd format like this:
UPDATE A2IDB3F_J SET DATE_OF_BIRTH = (SELECT MONTH_TEXT FROM MONTH_LOOKUP WHERE (SELECT CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(DATE_OF_BIRTH / 10000 AS INTEGER) * 100) = MONTH_NUMBER) Will see if doing it with a substr function is any faster. Would that work on integer numbers? RBS -----Original Message----- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: 18 February 2007 18:53 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Month string from yyyy-mm-dd RB Smissaert wrote: > Is it possible with the date-time functions to get the month as a string, so > January etc. from the date in the format yyyy-mm-dd? Doesn't look like it. Nothing in the wiki and I couldn't see anything in the source either. I suppose you could use a big case statement if you wanted to avoid joining with a month table. Martin ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
