>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%';

'timestamp' is a fixed string containing 9 alphabetic characters.
`timestamp` is a column name.
timestamp is a keyword and it can't be used as a column name unless you
backquote (``) it.

>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

I see absolutely nothing in the above query that says "inout as test".


>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...