Re: [sqlite] sqlite function list?

2007-06-04 Thread John Stanton
Scott Baker wrote: Is there a list somewhere (I can't find it on the wiki) of all the functions (specifically math) functions that sqlite understands? I'm thinking things like: int, round, floor, ceil, sqrt etc. You have the source. They are all presented there and you can add more if you cho

Re: [sqlite] sqlite function list?

2007-06-04 Thread Trey Mack
al Message - From: "Scott Baker" <[EMAIL PROTECTED]> To: Sent: Monday, June 04, 2007 3:43 PM Subject: [sqlite] sqlite function list? Is there a list somewhere (I can't find it on the wiki) of all the functions (specifically math) functions that sqlite understands? I'm thi

Re: [sqlite] sqlite function list?

2007-06-04 Thread P Kishor
http://www.sqlite.org/lang_expr.html scroll down. On 6/4/07, Scott Baker <[EMAIL PROTECTED]> wrote: Is there a list somewhere (I can't find it on the wiki) of all the functions (specifically math) functions that sqlite understands? I'm thinking things like: int, round, floor, ceil, sqrt etc.

[sqlite] sqlite function list?

2007-06-04 Thread Scott Baker
Is there a list somewhere (I can't find it on the wiki) of all the functions (specifically math) functions that sqlite understands? I'm thinking things like: int, round, floor, ceil, sqrt etc. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 -

Re: [sqlite] sqlite function

2004-04-02 Thread D. Richard Hipp
Roy Black wrote: Because sqlite doesn't have built-in [date/time] functions http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 - To unsubscribe, e-mail: [EMAIL PR

Re: [sqlite] sqlite function

2004-04-02 Thread Puneet Kishor
Roy Black wrote: Hello, I am facing a problem with sqlite. I have no clue how to select records with a column (DateTime) between two dates. Because sqlite doesn't have built-in functions I have to select * from a_table and then using code to remove records. I think this this way is not a good ide

[sqlite] sqlite function

2004-04-02 Thread Roy Black
Hello, I am facing a problem with sqlite. I have no clue how to select records with a column (DateTime) between two dates. Because sqlite doesn't have built-in functions I have to select * from a_table and then using code to remove records. I think this this way is not a good idea, it destroys all