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

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

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

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment Cancel reply