[alanrenouf]

Since upgrading my version of MySql from a very old version to the most current, one of my scripts no longer works.

update Messages set msgdate=date_format('03-03-03','%d %m %y') where id = 552

I just get a blank date all the time in msgdate any ideas ?

Thanks

Alan

[Stefan]

not sure, but maybe you should issue the command in CAPS ?

that's what I always do with (my)SQL commands.

[alanrenouf]

update Messages set msgdate=date_format('03-03-03','%d %m %y') where id = 552

for some reason I had to put the identifier in on the script now we have upgraded:

update Messages set msgdate=date_format('03-03-03','%d-%m-%y') where id = 552