Hi Guys,

in mysql i have 2 files (date files)

they are:

1)2007-08-27 13:20:03
2)August 13, 2007, 10:02 pm

they are displayed differently, is there a way i can work out the days elapsed between them like this? or do the time stamps need to be the same?

thanks for any help guys

Graham