Questions tagged [current-time]
77 questions
1
vote
1 answer
Oracle db: how to get current_time?
Mysql has current_time. What is the equivalent for oracle db?
select current_time
current_time
--------------------
15:30:16
eastwater
- 4,624
- 9
- 49
- 118
1
vote
0 answers
Why currentTimeMillis() reset to 1970
I developed an application with Android that saves a timestamp in a txt file and then uploads the file to a server so as I can check data.
The app worked always fine but now I have some strange behavior for one telephone.
The time stamps written…
Alex Gimondi
- 84
- 1
- 11
0
votes
1 answer
A way for static "now" in google sheet?
I would like to insert a formula with a checklist. That is, when I check the checklist, I want the date and time when I did it to appear in the cell next to it. Obviously, however, the "now" formula is updated with each click of the checklists, and…
0
votes
1 answer
Set CURRENT_TIMESTAMP as default value in strapi
I am using MySql in one of my project where backend is implemented using java and now I want to convert it to strapi project.
I have used some date field in database table and its default value is set to CURRENT_TIMESTAMP.
But I can not find any…
Drashti Kheni
- 1,065
- 9
- 23
0
votes
1 answer
Automating a script to pick up the local current time
How can I write the following script so that it picks up the local current time rather than me having to input the date each day? Note July 1 is the correct start date it's the second date that I have to change each time, as I'm importing a range of…
RoosterMagic22
- 69
- 6
0
votes
0 answers
Oracle SQL - Timestamp splits query result into 2 rows, Need all in one with
I need a time-based query (Random or Current) with all results in one row. My current query is as follows:
WITH started AS
(
SELECT f.*, CURRENT_DATE + ROWNUM / 24
FROM
(
SELECT
d.route_name,
d.op_name,
…
0
votes
0 answers
why videojs react player seeked to zero always when change
I am using React with Laravel as the backend and I receive the video name from Laravel but always when I change the video duration the video currentTime always go to zero
import React, { Component } from "react";
import VideoPlayer from…
0
votes
2 answers
How does the time function know the current time of the PC? Does it use the Internet to sync with a time server as the computers do?
How does the time function know the current time of the PC? I know how computers know the time. But how does the C++ time function implemented? Does it use the Internet to sync with a time server as the computers do? Or does it use the internal…
Ngoc Dat
- 15
- 5
0
votes
0 answers
Using the now() function in excel for conditional argument based on current time
I am trying to generate a cell on my shift report for work that automatically differentiates if it is for day-shift or night-shift. Our shifts are 12 hours (7-7), and shift reports are generally sent out within a 60 minute window around the turnover…
FalcoonnnnPUNCH
- 1
- 2
0
votes
1 answer
Regular expression to match latest/last month
I am new to regex and I would like to only match the latest/last month from below strings, as we can see only 202206 should be matched and in future if there is 202207 then it should only match 202207. For matching, after researching I found I can…
biggboss2019
- 220
- 3
- 8
- 30
0
votes
1 answer
Current time equal or less than in MySQL at 24 hour cycle
What's the best way to search less than current time at 24 hour cycle?
Database
+----+----------+-----------+
| id | time | name |
+----+----------+-----------+
| 1 | 07:00:00 | Breakfast |
| 2 | 12:00:00 | Lunch |
| 3 | 18:00:00 |…
Andrew Kin Fat Choi
- 326
- 3
- 8
0
votes
1 answer
How can I display the current simulation time on my heatmap animation with Gnuplot?
I am doing a heat transfer simulation into a cube and plotting the evolution through time with a 2D heatmap at mid-depth of the cube.
Here is a screenshot of the .gif heatmap animation launched with "Image Viewer":
I want to display on the .gif…
Jejouze
- 23
- 6
0
votes
1 answer
How to show current time in angular without using setInterval()
I want to show current active time in angular 11.
I did like this
setInterval(() => {
this.UKTime = formatDate(
Date.now(),
"dd-MM-yy hh:mm a",
"en-US",
"+0100"
);
this.SLTime = formatDate(
…
hanushi
- 119
- 6
- 14
0
votes
2 answers
How to show current time that should change every second or minute in angular 11
I am working on an angular 11 project.
I want to display current time and date and the time should change for every minute.
I tried with new Date(). But it shows only the time when the program run time.
This is what I tried. But it does not works…
hanushi
- 119
- 6
- 14
0
votes
1 answer
How to check if time in miliseconds is of today's time and it is under 10 seconds from the current time?
I am getting the timestamp from the server response in a string like..
KS100V1C1-2C3AE8176DC1\1 {"timestamp":"3:7:2021 16:01:38","ChannelId_1":100}
KS100V1C1-2C3AE8176DC1\1 {"timestamp":"3:7:2021 16:01:48","ChannelId_1":100}
KS100V1C1-2C3AE8176DC1\1…
Sid
- 2,792
- 9
- 55
- 111