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
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