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 -~----------~----~----~----~------~----~------~--~---
