Re: newbie - problems with Select and timestamp(14) calculation

On Thursday 18 October 2001 23:11 pm, p.whiter wrote: > Thanks for the reply, but the Timestamp(14) column (log_time) in my > DB saves the time as '20011018134612' this is the same format as the > NOW()+0 I think? > > I have tried various methods to get this to work. I've gone through > the manual and various books I have here but am having no joy at all. > > I have spent far too much time on this, it really should be quite > straightforward to compare against a Timestamp column!! If anyone > else has any ideas...... But have you spent any time *reading* the (fine) manual? As I suggested before, lookup UNIX_TIMESTAMP(), it should do what you want. rgds -- Jason Wong Gremlins Associates www.gremlins.com.hk