Re: [sqlite] Re: How to obtain the integer part of a result

2007-05-07 Thread Rich Shepard
On Mon, 7 May 2007, A.J.Millan wrote: I couldn't find that sentence (CAST) in the SQLite doc, neither in the Owens's book. Is it a SQL standard?, or a built-in SQL function? or a SQLite built-in aggregate funcion? CAST is part of the SQL-92 (and -99) standards. Rich -- Richard B.

RE: [sqlite] Re: How to obtain the integer part of a result

2007-05-07 Thread Griggs, Donald
Hello, A.J. Regarding: I couldn't find that sentence (CAST) in the SQLite doc, neither in the Owens's book. Is it a SQL standard?, or a built-in SQL function? or a SQLite built-in aggregate function? You'll want to see the *syntax* section of the website, under the very useful page on

Re: [sqlite] Re: How to obtain the integer part of a result

2007-05-07 Thread A.J.Millan
Igor: Thanks a lot. That korks!! Thanks also publicly to Filip who mail me the same response directly, but still I have a question: I couldn't find that sentence (CAST) in the SQLite doc, neither in the Owens's book. Is it a SQL standard?, or a built-in SQL function? or a SQLite built-in

[sqlite] Re: How to obtain the integer part of a result

2007-05-06 Thread Igor Tandetnik
A.J.Millan <[EMAIL PROTECTED]> wrote: I would like to know if there are a way to obtain a result without decimals (the integer part) in this query: CAST(expr AS INTEGER) Igor Tandetnik - To unsubscribe, send email to