A varying while

It seems to me that the while (unit of time) in time arithmetic is determined by the written program, and that one cannot vary it. In Access this is a character string (not that I recommend character string for this! but an enumerated type), and one can vary it: Datediff(Interval, When, Date()). MySQL s DATE_SUB(date,INTERVAL expr unit) takes two arguments, the lattar argument contains, o, say, INTERVAL 5 MONTH, and there is no varying "MONTH". Or is there?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org