SQL TUTORIAL TAGALOG VERSION PT 4.5 - DATE AND TIME FUNCTIONS

This is a beginner friendly tutorial of SQL.

We will cover each basic syntax of SQL I will break it down in several parts.

After we learn the basic syntax we will going to explore the intermediate to advance level of SQL.

PART I link:

Part I includes the Introduction and brief history of SQL.

PART II link:

Topics included in PART II are the following:
SELECT
SELECT DISTINCT
WHERE CLAUSE
ORDER BY
AND OPERATOR
OR OPERATOR
NOT OPERATOR

PART III link:

Topics included in PART III are the following:
LIMIT CLAUSE
SQL NULL VALUES
IN OPERATOR
BETWEEN OPERATOR
LIKE OPERATOR
SQL ALIASES
GROUP BY

PART 4.1 link:

SQL FUNCTIONS
1. AGGREGATE FUNCTIONS
Topics included in PART 4.1 are the following:
COUNT()
SUM()
MIN()
MAX()
AVG()

PART 4.2 link:

SQL STRING FUNCTIONS
Topics included in PART 4.2 are the following:
UPPER()
LOWER()
LENGTH()
SUBSTRING()
TRIM()
REPLACE()
CONCAT()
LPAD()
RPAD()

PART 4.3 link:

SQL NUMERIC FUNCTIONS
Topics included in PART 4.3 are the following:
ABS()
CEIL()
FLOOR()
ROUND()
POWER()
SQRT()
MOD()
PI()
EXP()
LOG()

PART 4.4 link:

SQL NULL FUNCTIONS
Topics included in PART 4.4 are the following:
IS NULL() / IS NOT NULL()
COALESCE()
NVL()
IFNULL()
ISNULL()
NULLIF()

PART 4.5 link:
SQL DATE AND TIME FUNCTIONS
Topics included in PART 4.5 are the following:
CURRENT_DATE() / CURRENT_TIMESTAMP()
DATEADD()
DATEDIFF()
DATEPART()
FORMAT() / TO_CHAR()
GETDATE() / SYSDATE() / NOW()
EXTRACT()
YEAR(), MONTH(), DAY()
DATE_TRUNC()
TIMESTAMPDIFF() / AGE()

Part 5 link:
SQL INNER JOIN

This tutorial is in Tagalog language.