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: 
There is no error message from MySQL with the text "No such function." I just did a grep on the whole source tree of MySQL 5.1, and that string does not occur anywhere (except in one comment).

My thought is that you aren't using MySQL, you're using SQLite. Because I *can* reproduce that error when I run the SQLite command-line shell:

```
$ sqlite3
sqlite> select curdate();
Error: no such function: curdate
sqlite> select now();
Error: no such function: now

```

In SQLite, the [function](http://www.sqlite.org/lang_datefunc.html) to get the current date is simply `date()`:

```
sqlite> select date();
2010-01-02

```
My inclination is to run a mysql repair install. if that didn't work, then i'd try to wamp reinst.