CG数据库 >> Date and Time Fundamentals in .NET and SQL Server

Video: .MP4, AVC, 1920×1080, 30 fps | Audio: English, AAC, 48 KHz, 2 Ch | Duration: 3h 20m | 2.23 GBInstructor: Ilya FofanovLearn how to work with date and time values properly, including DateTime and NodaTime (Noda Time)Key FeaturesMaster date- and time-related types from BCL and use Noda Time to write reliable codeApply best practices for working with date and time values in software developmentA practical course designed to help software developers write reliable code that works with dates and timesWhat You Will LearnDates and times in the .NET FrameworkUse Noda Time to write reliable codeDates and times in SQL ServerTime zonesAboutThis 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.


Date and Time Fundamentals in .NET and SQL Server的图片1