2012/2/10 Willian Gustavo Veiga <[email protected]>: > SQLite is a great database to unit test (TDD) applications. You can run it > in memory with your tests ... > > I've found a problem when I was unit testing my application. MySQL > (production database) supports EXTRACT SQL standard function. SQLite don't > support it. It would be great to have support in this standard.
http://www.sqlite.org/lang_datefunc.html > MySQL examples: > > Input: > SELECT EXTRACT(DAY FROM CURRENT_DATE) mysql> SELECT DAY(CURRENT_DATE); sqlite> SELECT strftime('%d',CURRENT_DATE); > Input: > SELECT EXTRACT( > MONTH FROM CURRENT_DATE ) mysql> SELECT MONTH(CURRENT_DATE); sqlite> SELECT strftime('%m',CURRENT_DATE); > Input: > SELECT EXTRACT( YEAR FROM CURRENT_DATE ) mysql> SELECT YEAR(CURRENT_DATE); sqlite> SELECT strftime('%Y',CURRENT_DATE); > Unfortunately, strftime isn't a solution. It's not a standard. Function strftime is your solution. Write two models. One for MySQL, one for SQLite. These databases are quite different and require different SQL queries. -- Kit _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
