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!
_______________________________________________
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/[email protected]
** 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.
