Hi, I do not know why Frank did not receive my mail 6 days ago ( I picked HIS mail out of the junk-folder, maybe the answer could be found in his), but I think his solving will result in problems every time the original date was the first day of a month.
Therefore, for the second time, I recommend the function SUBDATE, which (by the way) is much easier to read and will work even for the first day of a month and those days after the 10th. set <columnname> = subdate (<columnname>, 1) Elke SAP Labs Berlin > -----Original Message----- > From: Frank Reinprecht [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 20. Dezember 2006 20:56 > To: maxdb@lists.mysql.com > Subject: Re: Datatype Conversion Within a SQL Statement > > Hi List, > > it was, as everytime when nobody answers, too easy ;) After searching > again in the sqlstudio help I found what I need to solve it. I just > didn't took the right keywords while searching last time. > > The solution (if somebody else perhaps need this) is: > > update k_sonder_pos set > <columnname> = Date( > (SUBSTR(<columnname>,1,8)) & '0' & > SUBSTR(chr(NUM(SUBSTR(<columnname>,9,2)) -1),1,1) > ) > where > <columnname> <= '2007-01-31' and <columnname> >= '2007-01-01' > > Greetings, > Frank > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
