Date and Time Fundamentals in .NET and SQL Server | Packt

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

Dates and times in the .NET Framework
Use Noda Time to write reliable code
Dates and times in SQL Server
Time zones
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 –

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

If any links die or problem unrar, send request to

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.

Speak Your Mind

This site uses Akismet to reduce spam. Learn how your comment data is processed.