Single Row Functions by SQL

Published: 14 March 2021
on channel: Learn computer science

Single Row Functions by SQL
Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Describe the use of conversion functions
reating queries that require the use of numeric, character, and date functions
Using concatenation with functions
Writing case-insensitive queries to test the usefulness of character functions
Performing calculations of years and months of service for an employee
Determining the review date for an employee
SQL stores dates in an internal numeric format: century, year, month, day, hours, minutes, seconds.
The default date format is DD-MON-YY.
SYSDATE is a function returning date and time.
DUAL is a dummy table used to view SYSDATE
Add or subtract a number to or from a date for a resultant date value.
Subtract two dates to find the number of days between those dates.
Add hours to a date by dividing the number of hours by 24.

On this page of the site you can watch the video online Single Row Functions by SQL with a duration of hours minute second in good quality, which was uploaded by the user Learn computer science 14 March 2021, share the link with friends and acquaintances, this video has already been watched 58 times on youtube and it was liked by 1 viewers. Enjoy your viewing!