A day is a unit of time which is equal to an interval of 24 hours. It may be used for example for measuring the length of a period (see also period tag). For questions about dates or day of week rather consider tags like date or dayofweek.
Questions tagged [days]
554 questions
3
votes
4 answers
SQL calculate number of days of residency by month, by user, by location
I'm working on a query for a rehab organization where tenants (client/patients) live in a building when they first arrive, as they progress in their treatment they move to another building and as they near the end of treatment they are in a third…
Stan
- 595
- 3
- 9
- 20
3
votes
2 answers
Simple SQL Query: need this month data and previous month last 5 days data together
Need SQL query for this month data and previous month last 5 days data together:
SELECT
CONVERT(VARCHAR (10), wDate, 103) AS wDate,
Empid,
Process,
Model,
Qty,
Section,
Avlbl_Mins,
NP_Mins,
L_Mins,
NP_Reason AS NPReason,
…
Shankar Naren
- 55
- 7
3
votes
2 answers
Excel - How to count unique days in a list a duplicated days
Having a list of days suchs as:
01-giu-16
01-giu-16
01-giu-16
31-mag-16
31-mag-16
31-mag-16
31-mag-16
30-mag-16
I was looking for an excel formula that helps me count the number of unique days in the list (in this example 3)
Moreover I need the…
Noomak
- 371
- 5
- 19
3
votes
2 answers
finding number of days between two dates in the same year (c++)
I want to find the number of days between two months. I use Xcode but don't want to go through the trouble of installing boost or 'date.h', so I tried to do it more primitively but somehow the code keeps breaking at a certain point:
for (…
aspn
- 37
- 8
3
votes
1 answer
Days between dates for any day-count basis in R
Is there a function in R that calculates the number of days between two dates for any day-count basis? I am looking for something similar to the Matlab's daysdif function.
http://www.mathworks.com/help/finance/daysdif.html
In particular, I am…
Kamil Kosiński
- 107
- 1
- 6
3
votes
3 answers
Calculate days left to a specific date with JavaScript
I was trying to calculate the days left until a specific date. I know that there are a million different approaches and tutorials about it, but I wanted to write a code by myself. The problem is that the output of the function is "NaN". I am very…
Peter
- 1,110
- 10
- 25
3
votes
1 answer
Arangodb days between timestamps
Are there any built-in functions to find out the number of days between timestamps, add days, or find number of months between timestamps? Currently I'm storing dates in my documents as strings.
For example, if I do:
return…
Kenneth McMillion
- 33
- 2
3
votes
1 answer
Missing definition for "Days"
im trying to highlight the rows where the paid date is expired or it has 30 days to be expired.
when i build this it says it ... does not contain Definition for the ".Days".
im new to this please help
@foreach (var item in Model)
{
int daysLeft…
anfield8
- 33
- 5
3
votes
1 answer
Storing available dates of the week in MySQL
I'm working on a booking application, and in the backend, the user will be able to specify which days of the week he wants his venue available on. For instance, he might choose only to make his venue available on friday and saturday.
My question…
cbojer
- 63
- 1
- 5
3
votes
5 answers
how to select data from database based created_at today in rails
how to select data from database based created_at today in rails?
example :
[#
3lviend
- 243
- 5
- 13
3
votes
2 answers
java calendar display name style for day of month with ordinal indicator
Can Java be used to get different styles of day_of_month?
i.e. "21st" and "22nd" rather than just "21" and "22"?
also what are the 'st' and 'nd' at the end of dates called for future reference?
Greg
- 754
- 9
- 18
3
votes
2 answers
Most Concise Way to Determine Number of Days in a Month with Java (Using boolean Operators)
Recently I received this assignment in my Beginning Computer Science Class:
Write a program that asks the user to enter a month (1 = January, 2 = February, and
so on) and then prints the number of days of the month. For February, print
“28…
Holleyj66
- 33
- 1
- 4
3
votes
1 answer
Simple custom range in Ruby
I have a Rails named_scope which is using a condition to pull specific days of the week from the table like so:
:conditions => [ 'EXTRACT(DOW FROM bookdate) IN (?)', (1..6).to_a ]
The 1..6 date range will be a variable depending on the dates the…
holden
- 13,471
- 22
- 98
- 160
3
votes
4 answers
having problems in converting string date to weekday
I have a date string in the form month/day/year, i want to get only the day of the week for the selected date, and then match the day with my db for further processing. Kindly help
Saba Nazir
- 119
- 1
- 1
- 7
3
votes
2 answers
Number of days in quarter, SQL Server
I want to calculate the number of days per-quarter if start date and finish dates are given.
for example, one table has two columns, start date and finish date.
start date = 1st september and finish is 14th november.
I want to calculate the number…
Umashankar
- 31
- 1
- 2