CIS icon 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.
Function Type versus Parameter Type

TRIM Function

TRIM function

ABS Function

ABS function

MOD Function

MOD function

DateTime Functions

DateTime functions

Character Function Extensions

Character function extensions

Numeric Function Extensions

Numeric function extensions

DateTime Function Extensions

DateTime function extensions

DateTime Formatting

DateTime formatting

Casting Functions

Casting functions
Privacy Policy ©2004 - 2025  Bill Bennett Enterprises - All Rights Reserved.   View YouTube page.