Regarding rtrim, see: http://www.mail-archive.com/[EMAIL PROTECTED]/msg26666.html
/Cheers Erik On Jan 22, 2008 9:23 AM, Erik Andersson <[EMAIL PROTECTED]> wrote: > Hi > > I'm running sqlite 3.3.8. > > Examples: > > sqlite> select ticket,max(value) from ticket_custom where > name='time_spent' and ticket>2500; > 2626|9 > > sqlite> select ticket,max(CAST(value AS int)) from ticket_custom where > name='time_spent' and ticket>2500; > 2626|182 > > sqlite> select ticket,max(cast(value as int)) from ticket_custom where > name='time_spent' and ticket>2500; > 2626|182 > > Cheers / Erik > > On Jan 21, 2008 10:24 PM, rupert thurner < [EMAIL PROTECTED]> > wrote: > > > > > i tried: > > select cast(rtrim(value,'%') as int) from ticket_custom where name = > > 'progress'; > > > > both, cast, and rtrim give an error, but maybe i'm just misspelling > > the statement. does this work for you? which sqlite version are you > > using? we have 3.2.2. > > > > rupert. > > > > On Jan 21, 8:09pm, "Erik Andersson" <[EMAIL PROTECTED]> wrote: > > > Details on: http://www.sqlite.org/lang_expr.html > > > > > > Cheers / Erik > > > > > > On Jan 21, 2008 6:54 PM, Erik Andersson < [EMAIL PROTECTED]> wrote: > > > > > > > CAST(afield AS INT) > > > > > > > Cheers / Erik > > > > > > > On Jan 21, 2008 5:01 PM, rupert thurner < [EMAIL PROTECTED]> > > wrote: > > > > > > > > hi, > > > > > > > > is it somehow possible to sum up a custom field? i could not find > > a > > > > > sqlite function to convert the text to a number: > > > > > > > > rupert. > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
