MySQL Date_Format based on today's date and another column?

Posted by JM4 on Stack Overflow See other posts from Stack Overflow or by JM4
Published on 2011-02-28T15:15:19Z Indexed on 2011/02/28 15:25 UTC
Read the original article Hit count: 203

Filed under:
|
|

I am aware of the MySQL Date_Format function but am looking to achieve the following:

I have on column with a day date in 2 digit format (01-30). I am trying to update another date formatted field with the current year, the next month (m+1) and the day field mentioned previously.

In PHP i would do this using mktime function but this must be done using mysql calls only.

Is it possible to transform in this way?

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql