Each one of the Date classes are for specific purposes: If you want to use your Date in an SQL/JDBC context, use the java.sql.Timestamp. java.util.Date is the old Java API, it is not thread safe, you can difficultly handle time zoning, and on the top of all, it is poorly designed: one simple uniformity is … Read more
You can do it like this without loops SELECT p.date, COALESCE(a.value, 0) value, p.grp_no FROM ( SELECT grp_no, date FROM ( SELECT grp_no, MIN(date) min_date, MAX(date) max_date FROM tableA GROUP BY grp_no ) q CROSS JOIN tableb b WHERE b.date BETWEEN q.min_date AND q.max_date ) p LEFT JOIN TableA a ON p.grp_no = a.grp_no AND … Read more
Can someone explain how Date.UTC works Date.UTC creates a timevalue for the provided year, month, date, etc. without any offset. So if the client machine is set for, say, UTC +05:00 then: var d = new Date(Date.UTC(2013, 11, 30, 12, 0, 0)); will create a date equivalent to noon on 30 December 2013 at Greenwich. … Read more
It works if ‘ is replaced with ” into this command on the script – STAMP=`date –date=”$1 day ago” +%y%m%d` The clue was the two different character ` and ‘ used in the error response – date: invalid date `$1 day ago’ An expert in bash scripting (not me) can probably explain why this has … Read more
This happens if you do it to any month that doesn’t have 31 days (i.e. 3 months would work just fine, but 1 month, or 6, or 8 would all make this happen). If you do Date.today – 1.month, it looks like Rails sees that 9/31/2011 isn’t a valid date, so it kicks it back … Read more
The best practice is usually precisely NOT to think in term of heavy date objects but to store a point in time. This is typically done by storing a value that doesn’t suffer from corner cases nor from potential parsing problems. To do this, people usually store the number of milliseconds (or seconds) elapsed since … Read more
You can use the numpy.timedelta64 object to perform time delta calculations on a numpy.datetime64 object, see Datetime and Timedelta Arithmetic. Since a year can be either 365 or 366 days, it is not possible to substract a year, but you could substract 365 days instead: import numpy as np np.datetime64(‘2014-12-31′) – np.timedelta64(365,’D’) results in: numpy.datetime64(‘2013-12-31’)
Do it like this: SET DATEFIRST 1 — Define beginning of week as Monday SELECT […] AND WorkDate >= dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate())) AND WorkDate < dateadd(day, 8-datepart(dw, getdate()), CONVERT(date,getdate())) Explanation: datepart(dw, getdate()) will return the number of the day in the current week, from 1 to 7, starting with whatever you specified using SET … Read more