MySQL – Date and Time Functions In MySQL, we have a set of functions using which we can manipulate the date and time values. Following are the MySQL date time functions − Sr.No. Name & Description 1 This function adds two given dates 2 This function adds given time values 3 This function converts from […]
Category Archives: mysql
MySQL – UUID Table of content The MySQL UUID function The MySQL UUID() function is used to generate “Universal Unique Identifiers” (UUIDs) in accordance with RFC 4122. UUIDs are designed to be universally unique, even when generated on different servers. The UUID is generated using a combination of the current timestamp, the unique identifier of […]
MySQL – Aggregate Functions In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. MySQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the MySQL aggregate functions […]