Re: [sqlite] sqlite function

[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 idea, it destroys all
advantages of sqlite.
Any good idea to deal with this issue?

Thanks

hmmmmmmmm.... http://www.sqlite.org/lang.html

expression
expr ::=        expr binary-op expr |
expr like-op expr |
unary-op expr |
( expr ) |
column-name |
table-name . column-name |
database-name . table-name . column-name |
literal-value |
function-name ( expr-list | * ) |
expr ISNULL |
expr NOTNULL |
expr [NOT] BETWEEN expr AND expr |
expr [NOT] IN ( value-list ) |
expr [NOT] IN ( select-statement ) |
expr [NOT] IN [database-name .] table-name |
( select-statement ) |
CASE [expr] ( WHEN expr THEN expr )+ [ELSE expr] END
like-op ::=     LIKE | GLOB | NOT LIKE | NOT GLOB
Try the "expr BETWEEN expr AND expr"

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]