On Wed, Jun 18, 2014 at 4:24 PM, < [email protected]> wrote:
> On 2014-06-18 13:16, Stephen Russell wrote: > >> On Wed, Jun 18, 2014 at 11:54 AM, < >> [email protected]> wrote: >> >> I need to create a column in my MySQL table that is the first day of the >>> month for the other column with a real date in it. So DateFilled = >>> 20140617 and I need my new column DOSMonth to be 20140101. >>> >>> Suggestions? I got a DATEADD MS-SQL tip from my colleague but that >>> doesn't translate to MySQL well, and the DATE-ADD function in MySQL >>> doesn't >>> seem to be what I need. >>> ------------- >>> >> >> >> http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html >> >> Pick any two to play with. >> > > > Thanks Steve. I had found that just after posting and replayed the > solution here (which I'm sure you've seen by now). Thanks though! > --------------- I am use to doing the select dateadd(dd, -(Day(getdate()))+1, getdate()) -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyjtxnmjix7h4lakwf2ogkhxyqvkfz9jw5vscco-lzo...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
