performing functions on live data
Posted: Thu Sep 04, 2003 3:28 pm
MySQL.
For a table which include a DATE column named EndDate, I am trying to perform the following action:
SELECT day(EndDate) from tablename;
I must have the syntax wrong somehow, because it just spits me an error 1064, but I've tried lots of variations on this based on the examples in the MySQL manual, and they all do the same. Is there something I need to do to get it to be able to process live data?
thanks
For a table which include a DATE column named EndDate, I am trying to perform the following action:
SELECT day(EndDate) from tablename;
I must have the syntax wrong somehow, because it just spits me an error 1064, but I've tried lots of variations on this based on the examples in the MySQL manual, and they all do the same. Is there something I need to do to get it to be able to process live data?
thanks