I'm creating a Jasper report that includes the following parameters:
DATESTART (Date)
DATEEND (Date)
These parameters indicate a date range for a field called DATECREATED (Timestamp) which includes times. I would like the date range to be INCLUSIVE, that is, if I filter for "Jan 1, 2009" to "Jan 31, 2009", any DATECREATED value on Jan 31, 2009…
I am currently doing a dissertation about the implications or dangers that today's software development practices or teachings may have on the long term effects of programming.
Just to make it clear: I am not attacking the use abstractions in programming. Every programmer knows that abstractions are the bases for modularity.
What I want to…
I'm trying to create a weekly calendar that looks like this: http://dhtmlx.com/docs/products/dhtmlxScheduler/sample_basic.html
How can I calculate every week date? For example, this week is:
Monday - Sunday
7 June, 8 June, 9 June, 10 June, 11 June, 12 June, 13 June
I don't understand why async as described here
http://www.rebol.com/article/0050.html
is no more available. Will it return back any time soon or has the name changed ?
How would you store a time or time range in SQL?
It won't be a datetime because it will just be let's say 4:30PM (not, January 3rd, 4:30pm).
Those would be weekly, or daily meetings.
The type of queries that I need are of course be for display, but also later will include complex queries such as avoiding conflicts in schedule.
I'd rather pick…
I wrote a function
toBeautyString(epoch) : String
which given a epoch, return a string which will display the relative time from now in hour and minute
For instance:
// epoch: 1346140800 -> Tue, 28 Aug 2012 05:00:00 GMT
// and now: 1346313600 -> Thu, 30 Aug 2012 08:00:00 GMT
toBeautyString(1346140800)
-> "2 days and 3 hours…
Where can I find some examples on how to manipulate the time objects by days/hours/etc?
I would like to do this:
time.now_by_hour #=> "Tue Jun 15 23 MST 2010"
time.now_by_day #=> ""Tue Jun 15 MST 2010"
time.now_by_hour - 4.weeks - 3.days #=> "Sat May 15 MST 2010"
What is the recommended order of operations? The reason for…
i created new registry entry using
RegCreateKeyEx(HKEY_LOCAL_MACHINE, TEXT("Software\XXXXXX\Test"), 0, NULL, 0, 0, NULL, &hkey, &dwDisposition)
Now i want to save current system time data and year to the newly created registry for later retrival
How can i implement it in VC++ using RegSetKeyValue. I tried but faile dto…
I have a MVC3 application in which i want to set a timespan to for example 2 days and 5 hours.
when i enter 02:05:00:00 it gives me the following exception:
System.OverflowException: SqlDbType.Time overflow. Value '2.05:00:00' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999.
When i enter 05:00:00 it…
I have a table called users where I have two columns: name and created_at. created_at column column is of type datetime and it stores the datetime when this user was created.
I need to know the number of users created for a given date range. Let's say I ask give me user report between 1-nov-2010 and 30-nov-2010 . I need…
Hay, i have a field in one of my models which saves the creation date of an object
created_on = models.DateTimeField(blank=False, auto_now_add=True)
This works as expected.
In my templates i want to list objects like this
June 15
{{ objects here which was created on June 15 }}
June 14
{{ objects here which was…
Hi -
I'm trying to isolate duplicates in a 500MB database and have tried two ways to do it. One creating a new table and grouping:
CREATE TABLE test_table as
SELECT * FROM items WHERE 1 GROUP BY title;
But it's been running for an hour and in MySQL Admin it says the status is Locked.
The other way I tried was to…
Hello.
I'm looking for help deciding on which database system to use. (I've been googling and reading for the past few hours; it now seems worthwhile to ask for help from someone with firsthand knowledge.)
I need to log around 200 million rows (or more) per 8 hour workday to a database, then perform…
I can't seem to find this and I feel like it should be easy. In Ruby on Rails, how do I take:
2010-06-14 19:01:00 UTC
and turn it into
June 14th, 2010
Can I not just use a helper in the view?
Hey guys, i've this theme of the week script, easy, just post like normally, save in database and echo it in a column.
But since its theme of the week, i would like it to automatically renew the value to say "none" or "not set" after a week. I know cron jobs could do this but is there another way?…
Many enterprises are reducing travel, conference, and training budgets for their developers without any change in expectation for the results those developers must deliver. How can you keep up?
Well, some months back we offered you a Virtual Developer Day on the subject of building Rich…
August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running a…
Today's $10 deal of the day at http://www.apress.com/info/dailydeal is
Ultra-Fast ASP.NET: Building Ultra-Fast and Ultra-Scalable Websites Using ASP.NET and SQL Server by Richard Kessig - ISBN 978-1-4302-2383-2
I won a copy of this book at 101 Books. Richard Kessig is an…