MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Introduction to Dates and Times in SQL Server

Course Summary

The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer such as DATEPART(), DATEFROMP


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Course Contents
        ◦ Module Contents
        ◦ Database Version
        ◦ Data Used in Course
        ◦ SELECT w/o FROM
        ◦ Missing Topics
        ◦ DATEFORMAT Warning
        ◦ DATEFIRST and @@DATEFIRST
        ◦ Precision of Numeric Constants
        ◦ Precedence
        ◦ Summary
    ● Quick Start Guide
        ◦ Introduction
        ◦ Module Contents
        ◦ Data Types
        ◦ Congruence
        ◦ String Literals
        ◦ Conversion Functions
        ◦ Additional Functions
        ◦ Summary
    ● DATE Data Type
        ◦ Introduction
        ◦ Module Contents
        ◦ The DATE Data Type
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● TIME Data Type
        ◦ Introduction
        ◦ Module Contents
        ◦ The TIME Data Type
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● SMALLDATETIME Data Type
        ◦ Introduction
        ◦ Module Contents
        ◦ The SMALLDATETIME Data Type
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● DATETIME and DATETIME2 Data Types
        ◦ Introduction
        ◦ Module Contents
        ◦ The DATETIME/DATETIME2 Data Types
        ◦ Storage
        ◦ Initialization
        ◦ Operations
        ◦ Summary
    ● String Literals
        ◦ Introduction
        ◦ Module Contents
        ◦ A Literal Overview
        ◦ The DATE Literal
        ◦ The TIME Literal
        ◦ The SMALLDATETIME Literal
        ◦ The DATETIME Literal
        ◦ The DATETIME2 Literal
        ◦ Summary
    ● Conversion Functions
        ◦ Introduction
        ◦ Module Contents
        ◦ The DATEFROMPARTS() Function
        ◦ The TIMEFROMPARTS() Function
        ◦ The SMALLDATETIMEFROMPARTS() Function
        ◦ The DATETIMEFROMPARTS() Function
        ◦ The DATETIME2FROMPARTS() Function
        ◦ The CAST() Function
        ◦ The CONVERT() Function
        ◦ The FORMAT() Function
        ◦ Summary
    ● Additional Functions
        ◦ Introduction
        ◦ Module Contents
        ◦ DAY()/MONTH()/YEAR() Functions
        ◦ EOMONTH() Function
        ◦ GETDATE()/CURRENT_TIMESTAMP
        ◦ SYSDATETIME() Function
        ◦ DATEPART()/DATENAME() Functions
        ◦ DATEADD() Function
        ◦ DATEDIFF() Function
        ◦ Summary
    ● Date/Time Manipulations
        ◦ Introduction
        ◦ Module Contents
        ◦ Elementary Reminders
        ◦ Adding To and Subtracting From
        ◦ Converting To and From
        ◦ Converting to Numeric Values
        ◦ Zeroing Out the Date or Time
        ◦ First Days and Last Days
        ◦ Next Monday
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top