C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL Date/Time makedate() FunctionThe makedate() is a MySQL date/time function. It is used to make the date of the given year and number of days. Syntaxselect makedate(year, number_of_days); Parameter:Year : 4 digit year to find date Number_of_days : total number of days, should be greater than zero. Returns:This function returns the date for a certain year and day-of-year value. Example 1Select makedate(2018, 45); Output: Example 2Select makedate(2020, 100); Output:
Next TopicMySQL datetime
|