<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Well, that's MySQL-specific. Thom hasn't yet said what flavor of SQL he's using.<br><br>Personally, as someone who's had to do plenty of weekly date calcs from SQL syntax, yes, date_add and date_sub are your friends. When you need to render DATE data types into a humanly readable format, use date_format.<br><br>As someone who claims to be the premier MySQL guru of Southern California, I'll take on your problem in full stride. Send me the structure of your tables and a description of what you're trying to do...<br><br><br>Solomon Chang<br><br><br>--- On <b>Tue, 10/28/08, Alan Horn <i><ahorn@deorth.org></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">From: Alan Horn <ahorn@deorth.org><br>Subject: Re: [SGVLUG] Can SQL even do this?<br>To: "SGVLUG Discussion List."
<sgvlug@sgvlug.net><br>Date: Tuesday, October 28, 2008, 8:37 PM<br><br><pre>On Tue, 28 Oct 2008, John E. Kreznar wrote:<br><br>> -----BEGIN PGP SIGNED MESSAGE-----<br>> Hash: SHA1<br>><br>> "Emerson, Tom \(*IC\)"<br><Tom.Emerson@wbconsultant.com> writes:<br>><br>>> I've got an "interesting" problem -- ... I'm not<br>even sure how to<br>>> convert "11/02/2008 + 3" to get "11/16/2008" ...<br>><br><br>A quick net search turns up this :<br>http://www.devshed.com/c/a/MySQL/Date-Arithmetic-With-MySQL/3/<br><br>mysql has the DATE_ADD and DATE_SUB functions.<br><br>They do what you would expect.<br><br>Cheers,<br><br>Al<br><br></pre></blockquote></td></tr></table><br>