Re: FN-FORUM: SQL Help (probably an easy one)

date posted 16th January 2007 16:56

On Tuesday 16 Jan 2007 11:19 am, Dave Cross wrote:

> What datatype is your timeadded column? It is a datetime column isn't
> it? I mean everyone stores dates and times in a datetime column don't
> they? Anything else would be mad.

He said it's a timestamp.

FROM_UNIXTIME(timeadded, '%c') should do the trick.