Stack Overflow
Stack Overflow

Questions tagged [hour]

457 questions
3
votes
3 answers

MySQL - How to select rows with the min(timestamp) per hour of a given date

I have a table of production readings and need to get a result set containing a row for the min(timestamp) for EACH hour. The column layout is quite simple: ID,TIMESTAMP,SOURCE_ID,SOURCE_VALUE The data sample would look like: 123,'2013-03-01…
mwm4
  • 51
  • 1
  • 1
  • 3
3
votes
2 answers

Return the time(int) in a String method

So I have this method that returns the time when a tv-show ends(e.g.: 21:15),but when the hour or minute is under 10 I need the method to return something like this : 21:05. I tried like this, but because msg1 and msg2 are type String they can't…
JoMP
  • 49
  • 1
  • 5
3
votes
1 answer

Add Field that has hrs and mins value

Im trying to display the total for each project group. The Problem is that all the values for that field are recorded like so: 0h 06m The sum is displaying as: 0 with the following code. How do i display the total result in proper HH:MM…
Hector
  • 682
  • 3
  • 14
  • 27
3
votes
3 answers

Get all full hours of every day of a year

I need to get / print on command line every full hour of every day of a given year, e.g. 2011 but I am struggling to code it in Java. Has anybody ever coded this issue?
Tunc Jamgocyan
  • 321
  • 2
  • 7
  • 18
3
votes
4 answers

Summing time past 24 hours

I have the following method to sum time: public static String sumTime(String date1, String date2) throws ParseException { Calendar calendar = Calendar.getInstance(); SimpleDateFormat formatter = new SimpleDateFormat("HH:mm:ss.SSS"); …
ReX
  • 88
  • 2
  • 7
3
votes
3 answers

Select interval of time series object by date and time

My question is about how to manage the dates and times in an air quality database, which saved data every ten minutes all day, every day from 2002 through 2008. I want to generate several analysis and plots, but referring only to the morning peak…
Leonardo Cantor
  • 31
  • 1
  • 3
2
votes
4 answers

Zero-pad hour in DateFormat

I am trying to display a time difference into a string which follows the form 00:00:00 (hours:minutes:seconds), zero-padded. I have the following code: long timeDiff = System.currentTimeMillis() - mStartRecordingTime; time =…
pilcrowpipe
  • 2,528
  • 6
  • 29
  • 41
2
votes
1 answer

How can I prevent my Google App Engine cron jobs from burning through all my instance hours?

I have a google app engine where I have scheduled several cron jobs as database cleanup tasks, but these cron jobs are burning through all my instance hours (front or back), even though the actual processing time of each of these jobs is almost…
BrianE
  • 23
  • 3
2
votes
2 answers

Round up half of the hour in pandas

round() function in pandas rounds down the time 07:30 to 07:00 But I want to round up any time which passes the 30 minutes (inclusive). Eg. 07:15 to 07:00 05:25 to 05:00 22:30 to 23:00 18:45 to 19:00 How to achieve this for a column of a dataframe…
learner
  • 196
  • 9
2
votes
1 answer

Selecting data from the start of every hour

I have an MS Access database table that populates every minute, and I need to write a query to select the data at the start of every hour. Does anyone how I would go about writing such a query? BOF_TOTAL EAF_TOTAL EAF BOF …
LaDante Riley
  • 521
  • 4
  • 14
  • 26
2
votes
1 answer

Uneditable text box time date hour

How can i show a date and time format of 21 October 2020 Wednesday 10:15am in a form of JS and HTML and put them in an uneditable text box?
user13959111
2
votes
2 answers

How do I create a table of a 28 hour clock, by 1 minute intervals?

I am not very familiar with using loops. I am trying to create a table like this: 00:00 00:01 00:02 ... 27:58 27:59 28:00 It is for data that runs into the next day, but is still considered part of the original day. I tried…
iRbaboon
  • 23
  • 4
2
votes
1 answer

how to make that my script posts every hour

I am making a script wich post every hour on twitter every case of coronavirus. I have it finish but idk how to make that it posts every hour. any idea? (if you could post the following script with the solution in would be perfect) import…
MemePlay
  • 29
  • 1
  • 5
2
votes
3 answers

Time inconsistencies in Python

I am facing some problems in a cross platform program: when I open a python shell in Linux and in Windows, I don't get the same time from the Epoch. In Linux, I tried to do dpkg-reconfigure tzdata. Currently, in linux I get that avec the…
Mr_Kaz
  • 73
  • 1
  • 9
2
votes
0 answers

AUTO ARIMA MODEL to predict hourly data in python

Datetime Y 2013-07-01 00:00:00 216.0 2013-07-01 01:00:00 210.0 2013-07-01 02:00:00 225.0 2013-07-01 03:00:00 216.0 2013-07-01 04:00:00 222.0 My data is in above format with hourly frequency... I would like to build a…
sreekar reddy
  • 23
  • 5
1 2 3
…
30 31