CodesJava

Easy learning with example program codes

FROM_DAYS() FUNCTION in MySQL

FROM_DAYS() FUNCTION
The MySQL FROM_DAYS function is used to get a date value for a numeric representation of the day. The various versions of MySQL supports the FROM_DAYS function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0 and MySQL 3.23.

Syntax:

FROM_DAYS( numeric_day )

Parameters:
numeric_day: It is used to specify the value which is the numeric representation of the day.

Example:

mysql> SELECT FROM_DAYS (736038);

Output:

 2015-03-16

Explanation:
The desired date value has been returned for a numeric representation of the day.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status