From: Martijn Tonies
Date: January 29 2009 9:06pm
Subject: Re: TIME variable issue
List-Archive: http://lists.mysql.com/mysql/216077
Message-Id: <001401c98255$85270dd0$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="utf-8";
	reply-type=original
Content-Transfer-Encoding: 7bit

>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