New Transact SQL Video Tutorial: SET Commands Often Used to Control Dates and Date Formats in Input or Export Data

SET Commands Often Used to Control Dates and Date Formats in Input or Export Data - view details

Even more in our series on using SET commands in TSQL, this video shows you how to handle different date formats and handling international dates. The more you understand how SQL Server works with dates, the more robust your code. Is '2005/05/01' May 1 or January 5? How about 2005-06-02 - February 6 or June 2? It's up to you!

This video is for SQL Server 2005 and SQL Server 2000.

Highlights from this video:

• Using DBCC USEROPTIONS to determine connection settings
• DATEFORMAT and DATEFIRST to control settings
• DATENAME, DATEPART and CAST/CONVERT to manage datetime data
• Accurately making decisions based on day of week

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 9:59 (7.08MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

Note: You must have the TSCC codec installed to view this video