Because 1/1/1601 was the start of the epoch. Take it from Raymond Chen: Why is the Win32 epoch January 1, 1601?🕗 The FILETIME structure records time in the form of 100-nanosecond intervals since January 1, 1601. Why was that date chosen? The Gregorian calendar operates on a 400-year cycle, and 1601 is the first year … Read more
It’s required unless the “partners in information interchange” agree to omit it. Quoting an earlier version of the ISO 8601 standard, section 4.3.2: The character [T] shall be used as time designator to indicate the start of the representation of the time of day component in these expressions. […] NOTE By mutual agreement of the … Read more
Within the scope of java.time-package, we can say: It is safer to use “u” instead of “y” because DateTimeFormatter will otherwise insist on having an era in combination with “y” (= year-of-era). So using “u” would avoid some possible unexpected exceptions in strict formatting/parsing. See also this SO-post. Another minor thing which is improved by … Read more
I found this piece of information and got it to work correctly. The data given to me was in string format so I needed to parse the string using kendo.parseDate before formatting it with kendo.toString. columns: [ { field: “FirstName”, title: “FIRST NAME” }, { field: “LastName”, title: “LAST NAME” }, { field: “DateOfBirth”, title: … Read more
The beauty of the React Native is that it supports lots of JS libraries like Moment.js. Using moment.js would be a better/easier way to handle date/time instead coding from scratch just run this in the terminal (yarn add moment also works if using React’s built-in package manager): npm install moment –save And in your React … Read more
Using equals() LocalDate does override equals: int compareTo0(LocalDate otherDate) { int cmp = (year – otherDate.year); if (cmp == 0) { cmp = (month – otherDate.month); if (cmp == 0) { cmp = (day – otherDate.day); } } return cmp; } If you are not happy with the result of equals(), you are good using … Read more
I think that in order to answer that question, we should think about the benefits of using UTC to store timestamps. I personally think that the main benefit to that is that the time is always (mostly) guaranteed to be consistent. In other words, whenever the timezone is changed, or DST applied, you don’t get … Read more
New answer using Mongo aggregation framework After this question was asked and answered, 10gen released Mongodb version 2.2 with an aggregation framework, which is now the better way to do this sort of query. This query is a little challenging because you want to group by date and the values stored are timestamps, so you … Read more
I ended up grabbing the total seconds difference using Carbon: $totalDuration = $finishTime->diffInSeconds($startTime); // 21 Then used gmdate: gmdate(‘H:i:s’, $totalDuration); // 00:00:21 If anyone has a better way I’d be interested. Otherwise this works.
Check out startOfDay([offset]). That gets what you are looking for without the pesky time constraints and its built in as of 4.3.x. It also has variants like endOfDay, startOfWeek, startOfMonth, etc.