Question: I have installed [WampServer 2.0](http://www.wampserver.com/en/index.php) with MySQL 5.1.33.

I can do Numeric and String functions like

`SELECT ABS(-2)`  
or  
`SELECT LOWER('ASD')`

but with [Date and Time Functions](http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html) such as

`SELECT CURDATE()`  
or  
`SELECT NOW()`

I get

```
Error : no such function: CURDATE

```

Am I doing something wrong, is there anything I need to install?

Any help about where to start investigating?

Answer: 
Many functions are different in SQlite and in MySQL (or any other product - if you except core functions, most functions provide the same functionality but with a different syntax). There is an open-source "compatibility library" implementing a large number of MySQL functions in SQLite [on the Kansas State University CIS website](http://sqlite-libs.cis.ksu.edu/)
If SQLite had the same features as SQL, it would be amazing. But fortunately for query types with date comparisons it is possible to use existing SQLite functions.

An example of how I was able to carry out my query was as follows:
***Using an interface type class declaring my ObjectDAO: 'PartidoDAO'.***

```
@Query("select * from partido where fpartido>=DATE() and epartido = 'Santiago Bernabeu'  ORDER BY fpartido LIMIT 1")
    Partido getMoreRecentPartido();

```

If you want more information about functions related to date data types consult the web I invite you to consult this resource.
[SQLite Date Functions](https://www.sqlitetutorial.net/sqlite-date-functions/).