(StartA <= EndB) and (EndA >= StartB) Proof: Let ConditionA Mean that DateRange A Completely After DateRange B _ |—- DateRange A ——| |—Date Range B —–| _ (True if StartA > EndB) Let ConditionB Mean that DateRange A is Completely Before DateRange B |—- DateRange A —–| _ _ |—Date Range B —-| (True … Read more
Jeff, your code is nice but could be clearer with constants (as suggested in Code Complete). const int SECOND = 1; const int MINUTE = 60 * SECOND; const int HOUR = 60 * MINUTE; const int DAY = 24 * HOUR; const int MONTH = 30 * DAY; var ts = new TimeSpan(DateTime.UtcNow.Ticks – … Read more
SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date)) for example SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) gives me 2008-09-22 00:00:00.000 Pros: No varchar<->datetime conversions required No need to think about locale
Summary of answers and other data: (please add yours) Do: Whenever you are referring to an exact moment in time, persist the time according to a unified standard that is not affected by daylight savings. (GMT and UTC are equivalent with this regard, but it is preferred to use the term UTC. Notice that UTC … Read more
An easy to understand and simple solution. // Save today’s date. var today = DateTime.Today; // Calculate the age. var age = today.Year – birthdate.Year; // Go back to the year in which the person was born in case of a leap year if (birthdate.Date > today.AddYears(-age)) age–; However, this assumes you are looking for … Read more
The Date object will do what you want – construct one for each date, then compare them using the >, <, <= or >=. The ==, !=, ===, and !== operators require you to use date.getTime() as in var d1 = new Date(); var d2 = new Date(d1); var same = d1.getTime() === d2.getTime(); var … Read more
datetime.strptime parses an input string in the user-specified format into a timezone-naive datetime object: >>> from datetime import datetime >>> datetime.strptime(‘Jun 1 2005 1:33PM’, ‘%b %d %Y %I:%M%p’) datetime.datetime(2005, 6, 1, 13, 33) To obtain a date object using an existing datetime object, convert it using .date(): >>> datetime.strptime(‘Jun 1 2005’, ‘%b %d %Y’).date() date(2005, … Read more
Timestamps in MySQL are generally used to track changes to records, and are often updated every time the record is changed. If you want to store a specific value you should use a datetime field. If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go … Read more
Use datetime: >>> import datetime >>> now = datetime.datetime.now() >>> now datetime.datetime(2009, 1, 6, 15, 8, 24, 78915) >>> print(now) 2009-01-06 15:08:24.789150 For just the clock time without the date: >>> now.time() datetime.time(15, 8, 24, 78915) >>> print(now.time()) 15:08:24.789150 To save typing, you can import the datetime object from the datetime module: >>> from datetime … Read more