A period of time is an interval, a span of time. You can also use it for questions related to the actual punctuation mark.
Questions tagged [period]
508 questions
0
votes
1 answer
How can i remove the side effects of cons?
I can get the odd elements of a list using the following code:
(define (odds lis)
(cond
((null? lis) '())
((not (list? lis)) (quote (Usage: odds(list))))
((null? (car lis)) '())
((= (length lis) 1) (car lis))
(else (cons (car…
user1822789
- 45
- 2
- 6
0
votes
2 answers
SQL Period between two dates, query for every single day's average
I have several entries saved as follows:
ID | StartDate | Enddate | Amount
I do now want to query for every single day in this period to part the total amount between those dates.
For example
1 | 2012-01-01 | 2012-01-05 | 10
2 | 2012-01-04 |…
thoughtgap
- 51
- 2
- 10
0
votes
4 answers
Last n weekdays in sql where clausel
We are using MySQL as our database to store messages with timestamps. Is it possible to create a query that returns messages of the last n weekdays?
I.e. if n is 4 and today is Tuesday, I want messages from this weeks Monday, last weeks Friday,…
Thomas
- 10,289
- 13
- 39
- 55
0
votes
1 answer
Calculate time period list between 2 time in php?
I want to generate 3 time-period-list column between two times.
if
$start_time = '08:00 AM';
$end_time = '10:00: PM';
Time Period List As:
Morning ----- Noon ----- Eve
8:00 AM 1:00 PM 6:00 PM
8:30 AM 1:30 PM 6:30 PM
9:00 AM …
Frank
- 2,285
- 7
- 43
- 68
0
votes
2 answers
SELECT returning total booking price
I have the following table SEASONS with time periods defining a booking prices for each period day;
ID, STARTDATE, ENDDATE, PRICE
6, 2012-06-01, 2012-06-30, 20
7, 2012-07-01, 2012-07-31, 35
8, 2012-08-01, 2012-08-31, 30
9, 2012-09-01,…
sbrbot
- 6,169
- 6
- 43
- 74
0
votes
2 answers
multiple date periods
In my MySQL DB I've got one table storing date periods. Each period row has PSTART and PEND columns defining period start and period end dates. How to create a query which will check if one particular date is within any of these periods or not?…
sbrbot
- 6,169
- 6
- 43
- 74
-1
votes
1 answer
sending a period to end a mail DATA telnet session in python
im using a telnetlib in python to connect to a simple mail server and send out an email; everything works fine until the very end after i enter the DATA command, you submit the body of your message and in order to submit the email in the server's…
mayotic
- 342
- 1
- 3
- 15
-1
votes
1 answer
Export Table out of Access Database to Dynamic Folder Directory
I have a table in my Access data base that I would like to export to a folder directory which is updated manually according to the following methodology (YYYY is the higher-level folder, YYYYMM is the sub-folder I would like to export the report…
DVEF
- 47
- 4
-1
votes
1 answer
How to calculate value for past periods in Google Data Studio
I have a page with a control filter witch is a list of years (I don't want to use a range period selector but allow users to click on year they want to analyse instead)
I am trying to set 4 scorecard in my GDS that show the value for the selected…
Romain MALTRUD
- 1
- 2
-1
votes
2 answers
Group by months using PERIOD_DIFF mysql
I have the following table name surveydb,I use mysql 5.7
PERIODE
SURVEY
2020-02-03
2
2020-02-04
3
2020-03-10
5
2020-03-11
4
2020-07-28
1
2020-08-28
3
2020-11-28
4
I Used the following query in mysql,
SELECT…
Bowo RN
- 1
- 1
-1
votes
2 answers
Finding the period of the signal in python
I'm newly learning and practicing python. My question is, how can find the period of the signal through the python? And in which different ways?
"A periodic signal (but only ploted on a bounded…
amy
- 23
- 8
-1
votes
1 answer
How to select all USERS who didnt POST, grouped by dates?
I have USERS table and POSTS table. I can easy select all users who posted from 01/01/2020 to 01/04/2020 and group the results by date:
User::whereDoesntHave('posts', function($query) use($first_date, $last_date) {
…
Nadiow White
- 1
- 1
-1
votes
1 answer
Determine month given time range and expand to multiple rows
Is there a way to extract month from a given time range, and apply it to prices based on that range?
Maybe best to illustrate by example. I have a range of prices with an offer start and end dates:
d = {'Price': [12, 11, 14], 'Offer_From':…
Polto
- 95
- 1
- 10
-1
votes
1 answer
How do we calculate the period times based on user's input of start-time and end-time for the day in angular?
I'm setting up a timetable project for school management. I wanted to get the start time and end time of the day by a school admin for which I'm using a modal dialog. The above image holds only static period times for 9 different periods with equal…
krishie
- 59
- 8
-1
votes
1 answer
vb net exclude periods between two datetime
Hello I am new with datetimes in VB net and I am trying to calculate time for some operations in productions. For example:
starTtime="01.12.2018 07:00"
endTime ="01.12.2018 15:00"
I have example two periods without working:
Pause1Start="01.12.2018…
Fikri
- 5
- 1
- 5