2014
Pluralsight
Scott Hecht
2h 58m
English

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(), DATEFROMPARTS(), DATEADD(), as well as many others.

01. Introduction
01. Introduction.wmv
02. Course Contents.wmv
03. Module Contents.wmv
04. Database Version.wmv
05. Data Used in Course.wmv
06. SELECT w o FROM.wmv
07. Missing Topics.wmv
08. DATEFORMAT Warning.wmv
09. DATEFIRST and @@DATEFIRST.wmv
10. Precision of Numeric Constants.wmv
11. Precedence.wmv
12. Summary.wmv

02. Quick Start Guide
01. Introduction.wmv
02. Module Contents.wmv
03. Data Types.wmv
04. Congruence.wmv
05. String Literals.wmv
06. Conversion Functions.wmv
07. Additional Functions.wmv
08. Summary.wmv

03. DATE Data Type
01. Introduction.wmv
02. Module Contents.wmv
03. The DATE Data Type.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

04. TIME Data Type
01. Introduction.wmv
02. Module Contents.wmv
03. The TIME Data Type.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

05. SMALLDATETIME Data Type
01. Introduction.wmv
02. Module Contents.wmv
03. The SMALLDATETIME Data Type.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

06. DATETIME and DATETIME2 Data Types
01. Introduction.wmv
02. Module Contents.wmv
03. The DATETIME DATETIME2 Data Types.wmv
04. Storage.wmv
05. Initialization.wmv
06. Operations.wmv
07. Summary.wmv

07. String Literals
01. Introduction.wmv
02. Module Contents.wmv
03. A Literal Overview.wmv
04. The DATE Literal.wmv
05. The TIME Literal.wmv
06. The SMALLDATETIME Literal.wmv
07. The DATETIME Literal.wmv
08. The DATETIME2 Literal.wmv
09. Summary.wmv

08. Conversion Functions
01. Introduction.wmv
02. Module Contents.wmv
03. The DATEFROMPARTS() Function.wmv
04. The TIMEFROMPARTS() Function.wmv
05. The SMALLDATETIMEFROMPARTS() Function.wmv
06. The DATETIMEFROMPARTS() Function.wmv
07. The DATETIME2FROMPARTS() Function.wmv
08. The CAST() Function.wmv
09. The CONVERT() Function.wmv
10. The FORMAT() Function.wmv
11. Summary.wmv

09. Additional Functions
01. Introduction.wmv
02. Module Contents.wmv
03. DAY() MONTH() YEAR() Functions.wmv
04. EOMONTH() Function.wmv
05. GETDATE() CURRENT_TIMESTAMP.wmv
06. SYSDATETIME() Function.wmv
07. DATEPART() DATENAME() Functions.wmv
08. DATEADD() Function.wmv
09. DATEDIFF() Function.wmv
10. Summary.wmv

10. Date Time Manipulations
01. Introduction.wmv
02. Module Contents.wmv
03. Elementary Reminders.wmv
04. Adding To and Subtracting From.wmv
05. Converting To and From.wmv
06. Converting to Numeric Values.wmv
07. Zeroing Out the Date or Time.wmv
08. First Days and Last Days.wmv
09. Next Monday.wmv
10. Summary.wmv

http://pluralsight.com/

Download File Size:455.48 MB

---