Howdy.
Am somewhat new to mySQL 5...in conjunction with phpTimeClock (open
source app) on a winXP sp2 box.

Trying to convert a column named timestamp (bingint(14)) so that it
displays the date in year month day using date_format(timestamp, '%Y%m
%e') with statement:

select date_format('timestamp', '%Y%m%e'),note from info where
fullname like 'martina%';

And I get:
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'inout as test, `inout` from info' at line 1

An example of the data in the timestamp column is 1172008033.

In addition, when attempting to add the column inout (varchar (50)) as
in
select notes, inout from info;

I get the same err whose err number is 1064.

Appreciate if someone could direct me to the correct syntax...

Thanks,

Rey