On 10 Feb 2012, at 3:00pm, Willian Gustavo Veiga wrote: > 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.
EXTRACT is /not/ a standard. A couple of SQL products support it, and they're not even compatible with each-other. SQLite has equivalent functions which you can find here: <http://www.sqlite.org/lang_datefunc.html> Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
