>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
| Thread |
|---|
| • TIME variable issue | Ajit Tirumalasetti | 29 Jan |
| • Re: TIME variable issue | Martijn Tonies | 29 Jan |
