Date and Time Fundamentals in .NET and SQL Server

Learn how to work with date and time values properly, including DateTime and NodaTime (Noda Time)

Key Features

Master date- and time-related types from BCL and use Noda Time to write reliable code
Apply best practices for working with date and time values in software development
A practical course designed to help software developers write reliable code that works with dates and times

What You Will Learn

Dates and times in the .NET Framework
Use Noda Time to write reliable code
Dates and times in SQL Server
Time zones

About

This course will help you build a solid foundation in working with dates and times in software development.

Almost all software works with dates and times in one form or another. However, dates and times give rise to many pitfalls even in very simple scenarios. We all know that security and logging are regular aspects of almost any program. Most developers have no idea how many bugs are concealed behind dates and times; they lie dormant in programs and can suddenly blow up your production code, causing very unfortunate repercussions. That's why working with dates and times is a fully fledged and very important aspect of software development.

This course covers the following topics:

•Date and Time fundamentals: Gregorian calendar, UTC, GMT, Atomic time, how computers store time, NTP, date and time formats based on standards and specifications, Epoch Time and Unit Time, and date and time scope and perspectives

•Time Zones: Definition (complex one), Daylight-Saving Time (DST), providers such as IANA or TZDB and Microsoft

•Date and Time in .NET: DateTime, DateTimeOffset, TimeZoneInfo, TimeSpan, Calendars, Stopwatch and many intrinsic details.

•Noda Time: overview, core types, unit testing

•A great number of best practices for working with dates and times: arithmetic on dates, parsing, calculating birthdays, scheduling events, date formats, ranges, and more.

In the end, we will recap what you have learned.

All the codes and supporting files for this course are available at -https://github.com/PacktPublishing/Date-and-Time-Fundamentals-in-.NET-and-SQL-Server