We are using TIME for calculating SLA and this sometimes involves a years time to hold in the time variable. Please suggest an alternative.
Define a proper "interval"-like construct??
TIME should be used for "time of day", even though MySQL supports storing more in it, doesn't mean it's a good idea.
With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
