Re: [sqlite] A question about dates

Carlos Suarez wrote: > I need to know how I can sum and count the field assoiated by record > more especifically this: > > I got several tables associated > ie: client --- buys >name idbuy >idcli idcli > date > and I need to count how many buys got every clien

Re: [sqlite] A question about dates

thanks for answers so quickly, I need to know how I can sum and count the field assoiated by record more especifically this: I got several tables associated ie: client --- buys name idbuy idcli idcli date and I need to count how many buys got every client

Re: [sqlite] A question about dates

Carlos Suarez wrote: > I need to know how I can split a date field with a slash in -, being > straight I need to convert the the date format > /mm/dd to -mm-dd replace('/mm/dd', '/', '-') http://sqlite.org/lang_corefunc.html Igor Tandetnik __

[sqlite] A question about dates

Hi, I need to know how I can split a date field with a slash in -, being straight I need to convert the the date format /mm/dd to -mm-dd or something alike because flex builder date format is with slash but sqlite operation results are return with (-) in example: STRFTIME('%J','20