A quick google points me to what looks like the solution. Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile … Read more
This will give you the deadline : select id, title, created_at + interval ‘1’ day * claim_window as deadline from projects Alternatively the function make_interval can be used: select id, title, created_at + make_interval(days => claim_window) as deadline from projects To get all projects where the deadline is over, use: select * from ( select … Read more
By default, MomentJS parses in local time. If only a date string (with no time) is provided, the time defaults to midnight. In your code, you create a local date and then convert it to the UTC timezone (in fact, it makes the moment instance switch to UTC mode), so when it is formatted, it … Read more
Ah, the Java Date class. Perhaps one of the best examples of how not to do something in any language, anywhere. Where do I begin? Reading the JavaDoc might lead one to think that the developers have actually got some good ideas. It goes on about the difference between UTC and GMT at length, despite … Read more
Use CURRENT_TIMESTAMP (or GETDATE() on archaic versions of SQL Server).
if (date1.getTime() > date2.getTime()) { alert(“The first date is after the second date!”); } Reference to Date object
Use Time.now + 10.days or even 10.days.from_now Both definitely work. Are you sure you’re in Rails and not just Ruby? If you definitely are in Rails, where are you trying to run this from? Note that Active Support has to be loaded.
I use this: My-File–2009-12-31–23-59-59.txt No spaces Double dashes to separate the pieces, making each piece easy to see Only one punctuation character (dash) making it easy to type No timezone because for me I’m always working in my local timezone; if I needed one I’d go with UTC and append “–UTC” after the time.
You need to use DateTime.ParseExact with format “dd/MM/yyyy” DateTime dt=DateTime.ParseExact(“24/01/2013”, “dd/MM/yyyy”, CultureInfo.InvariantCulture); Its safer if you use d/M/yyyy for the format, since that will handle both single digit and double digits day/month. But that really depends if you are expecting single/double digit values. Your date format day/Month/Year might be an acceptable date format for some … Read more
Your code could be reduced to SimpleDateFormat sdf = new SimpleDateFormat(“dd/MM/yyyy”); Date strDate = sdf.parse(valid_until); if (new Date().after(strDate)) { catalog_outdated = 1; } or SimpleDateFormat sdf = new SimpleDateFormat(“dd/MM/yyyy”); Date strDate = sdf.parse(valid_until); if (System.currentTimeMillis() > strDate.getTime()) { catalog_outdated = 1; }