SQL – MySQL TIME() Function
May 19, 2023
The MySQL TIME() function extracts the time part from a given time/datetime, and returns “00:00:00” if not a datetime/time, or NULL if expression is NULL.
SQL – MySQL TIME_FORMAT() Function
May 21, 2023
The MySQL TIME_FORMAT() function formats a time by a specified format.
SQL – MySQL TIME_TO_SEC() Function
May 20, 2023
The MySQL TIME_TO_SEC() function converts a time value into seconds.
SQL – MySQL TIMEDIFF() Function
May 23, 2023
The MySQL TIMEDIFF() function returns the difference between two time/datetime expressions (written in the same format).
SQL – MySQL TIMESTAMP() Function
May 23, 2023
The MySQL TIMESTAMP() function returns a datetime value based on a date or datetime value.
SQL – MySQL TO_DAYS() Function
May 24, 2023
The MySQL TO_DAYS() function returns the number of days between a date and year 0 (date “0000-00-00”).
SQL – MySQL TRIM() Function
June 13, 2023
The MySQL TRIM() function removes leading and trailing spaces from a string.
SQL – MySQL TRUNCATE() Function
June 26, 2023
The MySQL TRUNCATE() function truncates a number to the specified number of decimal places.
SQL – MySQL UCASE() Function
June 13, 2023
The MySQL UCASE() function converts a string to upper case.
SQL – MySQL UPPER() Function
June 13, 2023
The MySQL UPPER() function converts a string to upper case.
SQL – MySQL USER() Function
June 13, 2023
The MySQL USER() function returns the current user name and host name for the MySQL connection.
SQL – MySQL VERSION() Function
June 13, 2023
The MySQL VERSION() function returns the current version of the MySQL database, as a string.
SQL – MySQL WEEK() Function
May 25, 2023
The MySQL WEEK() function returns the week number for a given date (a number from 0 to 53).
SQL – MySQL WEEKDAY() Function
May 26, 2023
The MySQL WEEKDAY() function returns the weekday number for a given date.
SQL – MySQL WEEKOFYEAR() Function
May 27, 2023
The MySQL WEEKOFYEAR() function returns the week number for a given date (a number from 1 to 53).
SQL – MySQL YEAR() Function
May 28, 2023
The MySQL YEAR() function returns the year part for a given date (a number from 1000 to 9999).
SQL – MySQL YEARWEEK() Function
May 29, 2023
The MySQL YEARWEEK() function returns the year and week number (a number from 0 to 53) for a given date.
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!
