Re: TIME Difference Using 4.0.17

2005-04-07 Thread Jigal van Hemert
From: "shaun thornburgh" > I have a DATETIME COLUMN in my table and i need to be able to perform an > update on all colmns that are 48 hours old as specified in that column. As I > am using 4.0.17 I am unable to use the TIME() functions, is there another > way to do this? I tend to use constructio

Re: TIME Difference Using 4.0.17

2005-04-07 Thread Philippe Poelvoorde
shaun thornburgh wrote: Hi, I have a DATETIME COLUMN in my table and i need to be able to perform an update on all colmns that are 48 hours old as specified in that column. As I am using 4.0.17 I am unable to use the TIME() functions, is there another way to do this? Thanks for your help try d

TIME Difference Using 4.0.17

2005-04-07 Thread shaun thornburgh
Hi, I have a DATETIME COLUMN in my table and i need to be able to perform an update on all colmns that are 48 hours old as specified in that column. As I am using 4.0.17 I am unable to use the TIME() functions, is there another way to do this? Thanks for your help -- MySQL General Mailing List