SQL – MySQL LAST_DAY() Function
May 1, 2023
The MySQL LAST_DAY() function extracts the last day of the month for a given date.
SQL – MySQL LCASE() Function
June 13, 2023
The MySQL LCASE() function converts a string to lower-case.
SQL – MySQL LEAST() Function
March 24, 2023
The MySQL LEAST() function returns the smallest value of the list of arguments.
SQL – MySQL LEFT() Function
June 13, 2023
The MySQL LEFT() function extracts a number of characters from a string, starting from left.
SQL – MySQL LENGTH() Function
June 13, 2023
The MySQL LENGTH() function returns the length of a string in bytes.
SQL – MySQL LN() Function
March 26, 2023
The MySQL LN() function returns the natural logarithm of a number (greater than 0).
SQL – MySQL LOCALTIME() Function
May 2, 2023
The MySQL LOCALTIME() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL LOCALTIMESTAMP() Function
May 3, 2023
The MySQL LOCALTIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL LOCATE() Function
June 13, 2023
The MySQL LOCATE() function returns the position of the first occurrence of a case-insensitive substring in a string.
SQL – MySQL LOG() Function
March 27, 2023
The MySQL LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
SQL – MySQL LOG2() Function
March 29, 2023
The MySQL LOG2() function returns the natural logarithm of a number greater than 0 to base 2.
SQL – MySQL LOG10() Function
March 29, 2023
The MySQL LOG10() function returns the natural logarithm of a number greater than 0 to base 10.
SQL – MySQL LOWER() Function
June 13, 2023
The MySQL LOWER() function converts a string to lower case.
SQL – MySQL LPAD() Function
June 13, 2023
The MySQL LPAD() function left-pads a string with another string, to achieve a specified length.
SQL – MySQL LTRIM() Function
June 13, 2023
The MySQL LTRIM() function removes leading spaces from a string.
SQL – MySQL MAKEDATE() Function
May 4, 2023
The MySQL MAKEDATE() function creates and returns a date based on a year and a number of days value.
SQL – MySQL MAKETIME() Function
May 5, 2023
The MySQL MAKETIME() function creates and returns a time based on an hour, minute, and second value.
SQL – MySQL MAX() Function
June 29, 2023
The MySQL MAX() function returns the maximum value in a set of values.
SQL – MySQL MICROSECOND() Function
May 6, 2023
The MySQL MICROSECOND() function returns the microsecond part of a time/datetime (from 0 to 999999).
SQL – MySQL MIN() Function
March 31, 2023
The MySQL MIN() function returns the minimum value in a set of values.
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
Why 1SMARTchicken?
This site was built and is maintained to benefit my autistic son.
See More →
See More →
Thanks for your support!
Books
All are affiliate links. Thank you for your support!
