[SGVLUG] Can SQL even do this?

[Alan Horn]

On Tue, 28 Oct 2008, John E. Kreznar wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> "Emerson, Tom \(*IC\)" <Tom.Emerson at wbconsultant.com> writes:
>
>> I've got an "interesting" problem -- ... I'm not even sure how to
>> convert "11/02/2008 + 3" to get "11/16/2008" ...
>

A quick net search turns up this :
http://www.devshed.com/c/a/MySQL/Date-Arithmetic-With-MySQL/3/

mysql has the DATE_ADD and DATE_SUB functions.

They do what you would expect.

Cheers,

Al