On Sep 28, 4:55 pm, gordonb.5j...@burditt.org (Gordon Burditt) wrote:
> >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...

Howdy Gordon.
Thanks for replying and info on timestamp column.

I also backquoted the inout column as I had forgotten to mention that
both the mySQL query browser and HeidiSQL where showing inout in same
syntax colors as select...

So now with this statement I get the timestamp values (1184100363) and
the inout values (out, in, in for lunch):
select `timestamp`,date_format(`timestamp`, '%c%d%Y') as theDate,
`inout` from info where fullname like 'martina%';

However, in date_format conversion returns null for all values in that
column. As the 'timestamp' column is a BigInt then will have to figue
out how to convert this to a date, etc. Now to check back at
SorgeForge site for info, in any, on it conversion.

Thanks,
Rey