Computer Information Systems
Courses
Faculty
Glossary
Pathways
Resources
Support
Tutorials
Databases
/
servers
/
SQLServer
/
Queries
Module 9:
Table of Contents
Function Types
Character
Numeric
DateTime
Function Type vs Parameter Type
TRIM
ABS
MOD
DateTime Functions
Character Function Extensions
Number Function Extensions
DateTime Function Extensions
Function Types
Character
functions: return a single character value. Can be used anywhere in your program a character value is allowed.
Numeric
functions: return a single numeric value. Can be used anywhere in your program a numeric value is allowed.
DateTime
functions: return a single DateTime value. Can be used anywhere in your program a DateTime value is allowed.
TRIM Function
ABS Function
MOD Function
DateTime Functions
Character Function Extensions
Numeric Function Extensions
DateTime Function Extensions
DateTime Formatting
Casting Functions