Top "Hour" questions

How can I extract just the hour of a timestamp using standardSQL

How can I extract just the hour of a timestamp using standardSQL. I've tried everything and no function works. The …

google-bigquery hour

Oracle PLSQL truncate datetime to specific hours

I have an Oracle PLSQL code generating a list of datetime stamps and I would like to truncate them to …

oracle datetime plsql truncate hour

Android - Find out what hour of day it is

I want to use and alarmManager that sets a repeating alarm to go off on the hour, every hour. I …

android time intervals alarmmanager hour

How to do a cron job every 72 minutes

How would I get a cron job to run every 72 minutes? Or some not so pretty number like that?

cron scheduled-tasks hour

Extracting date, hour and minute from Instant.now() generated date

I have this code that generates a date and time, ZoneId z = ZoneId.of( "Africa/Nairobi" ); Instant instant = Instant.now(); …

java datetime hour zoneddatetime java.time.instant

How to calculate hour:minutes from total minutes?

For example i have 525 minutes, if we will divide it by 60 the result will be 8.75 But 1 hour have only 60 minutes …

php hour

How to update only the hour from a DATETIME field in MySQL?

I want to update a DateTime column where it will change the hours only without modifying anything else. I can't …

mysql sql datetime hour date-manipulation

Java Swing GUI hour glass

There is a JTabbedPane In my Swing program. When user clicks on a tab, the program takes a while to …

java swing user-interface hour

How to set hour minute in nsdate programmatically?

I have 2:01:20 PM format in one label; after some calculations, I need to change the hour and/or minute of …

objective-c iphone nsdate hour minute

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(…

mysql timestamp min hour