Forget it!!! I applied the same concept as Ed showed us years ago in
his Fox functions and it worked!
UPDATE MyTable
set DOSMonth = datefilled - INTERVAL DAY(datefilled) DAY + INTERVAL 1
DAY
:-)
(Isn't ProFox great, especially when you solve your own problems?!??
lol)
On 2014-06-18 12:54, [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.
Thanks,
--Mike
[excessive quoting removed by server]
_______________________________________________
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.
