If you're only concerned with the date and not the time-of-day, you can divide by (1000 * 60 * 60 * 24), or format and store it in ANSI date format (YYYYMMdd). But why on earth do you have an int(11) column for a date value in the first place? MySQL provides 3 data types (granted that one of them has the y2k38 bug).

db

07-31-2011, 08:15 PM

fortwnty420

I said the same thing.. why int(11) for date. :@:

I didn't choose the design actually.. It is for virtue_mart. that is the table structure that the system uses.. I was only concerned with the actual date..

Thanks for you help it is much appreciated!

Jeff-

08-01-2011, 10:29 AM

Tolls

What does that int(11) represent?
Can't really do any conversion without knowing what it is supposed to be...