Single Row Functions by SQL
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.
Nesta página do site você pode assistir ao vídeo on-line Single Row Functions by SQL duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Learn computer science 14 Março 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 58 vezes e gostou 1 espectadores. Boa visualização!
