Date and Time Fundamentals in .NET and SQL Server

Date and Time Fundamentals in .NET and SQL Server | Packt
English | Size: 2.23 GB
Genre: eLearning

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 –