On Tue, 2 Dec 2003 22:53:47 -0800 (PST) p shah <[EMAIL PROTECTED]> wrote: > What are the pros and cons for using Integer column > type for the date? > Please reply at the earliest.
Well there are *some* drawbacks but I dunno if they apply to you. For instance, using PHP, when I do a select on a datetime field it returns a string that looks like "2003-12-02 13:03:49" and I can print it directly. In the reverse direction (trying to input such data received from the user) I can run some validation tests on a string formatted like the above, tests which are easier to implement and more flexible than working with an integer. Also when trying to input data, the datetime field is flexible in that it accepts a subset of the above format where fields starting from the right can be missing (I can only input year and month for example). -- Skippy - Romanian Web Developers - http://ROWD.ORG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
