Page 1 of 1

Datepart

Posted: Fri Apr 07, 2006 3:49 pm
by btpwebdev
Hi,
I have a date system whereby my date comes from a mysql database such as '2006-01-04'. Is it possible to take only that date from the database; eg: so i can turn the year into a variable.


Chris.

Posted: Fri Apr 07, 2006 3:57 pm
by timvw
You can SELECT YEAR(datefield) instead of the datefield in your query...