I see these really need to be int or time types.
Is there no way they can default to NULL or blank?
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
mysql> select '3' - '1';
+-----------+
| '3' - '1' |
+-----------+
| 2 |
+-----------+
1 row in set (0.00 sec)
mysql> select time_format(subtime('6:10',':10'),'%H:%i');
+--------------------------------------------+
| time_format(subtime('6:10',':10'),'%H:%i') |
+--------------------------------------------+
| 06:00 |
+--------------------------------------------+
1 row in set (0.00 sec)
Thanks,
Jon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
