Convert date from Christian to Buddhist in MySQL

Question

I'm using DATE_FORMAT(NOW(),'%Y-%m-%d') in a MySQL query.

How can I also convert the date from a "Christian" year to a "Buddhist" year?

Answer 1

This may be an oversimplification, but if you simply want to add 543 years, you could use:

mysql> SELECT DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 543 YEAR),'%Y-%m-%d');
+------------------------------------------------------------+
| DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 543 YEAR),'%Y-%m-%d') |
+------------------------------------------------------------+
| 2558-07-10                                                 |
+------------------------------------------------------------+
1 row in set (0.00 sec)