Date and Time Functions

Introduction Installing and Configuring Architecture Databases and Tables Data Types Constraints CRUD Operations Operators Functions String Functions Numeric Functions Date and Time Functions Aggregate Functions GROUP BY HAVING Clause ORDER BY LIMIT and OFFSET DISTINCT Aliases WHERE Clause Logical Operators Pattern Matching (LIKE, REGEXP) NULL Handling CASE Expression Joins Self Join Cross Join UNION, UNION ALL, INTERSECT, EXCEPT (and MySQL alternatives) Subqueries Correlated Subqueries Common Table Expressions (CTE) Recursive CTE Views Stored Procedures Stored Functions Triggers Events (Event Scheduler) Transactions ACID Properties Isolation Levels Locks and Locking Mechanisms Deadlocks Indexes Composite Indexes EXPLAIN and Query Execution Plans Query Optimization Partitioning Replication Backup and Restore Users, Roles and Privileges Window Functions JSON Data Type and Functions Performance Schema and Monitoring