Questions tagged [current-time]
77 questions
3
votes
2 answers
How to get current date and time in ISO 8601 format in kotlin?
I am trying to get the current date and time in ISO 8601 format. My code below returns the date 14 days later and incorrect time. I need the correct format and current date for an api request.
val formatter =…

QThompson
- 1,599
- 3
- 16
- 40
2
votes
1 answer
How to get current time in FILETIME format?
How can I use PowerShell on Windows to get the current time in the Windows FILETIME format?
Something like this answer about Linux except for Windows, using the Windows FILETIME format (64-bit value representing the number of 100-nanosecond…

Tuor
- 875
- 1
- 8
- 32
2
votes
1 answer
Portable default to current datetime with JPA
I wrote for my column
class MyEntity {
@Column(columnDefinition="DATETIME(6) DEFAULT CURRENT_TIMESTAMP")
private LocalDateTime createdDate = LocalDateTime.now(ZoneOffset.UTC);
and it works in MySQL but fails in H2 which I use for automated…

Dims
- 47,675
- 117
- 331
- 600
2
votes
0 answers
Why is AVPlayer periodic observer showing current time before the start time on device?
With AVPlayer, after seeking to a specific time (let's say 0.5s) and calling play(), periodic observer fires few callbacks with player's currentTime() before the seek position.
Here's the code:
test wave file
import AVFoundation
class Player {
…

dontgonearthecastle
- 61
- 3
2
votes
1 answer
Firemonkey (Rad Studio 10.3.2) current time issue on Android
If there any solution how to fix mediaplayer. Currenttime on Android (Rad studio 10.3.2) ? Values not correct (sometimes negative values), on windows work fine

Nacer Allalouche
- 31
- 4
1
vote
1 answer
CURRENT_TIME and CURRENT_TIMESTAMP give different results in PostgreSQL
CURRENT_TIME and CURRENT_TIMESTAMP give different results in PostgreSQL. What is the reason of that? Why these are not in same timezone?
select current_timestamp, current_time;
results:
current_time
current_timestamp
09:13:30…

Tolga Cakir
- 725
- 1
- 7
- 13
1
vote
1 answer
current_timestamp in a PL/pgSQL function always returns the same value
I admit that after working more than 20 years with Oracle databases I find it hard not to think that way. Our new application uses now a PostgreSQL 12.8 instance and I need to write some SQL scripts that will display some progress information as the…

Julian
- 3,678
- 7
- 40
- 72
1
vote
1 answer
Anomaly inserting current_timestamp() into MariaDB table
I'm writing a program using Golang (1.17.8), storing information in a MariaDB (10.6.5) database. I often need to store a created_at field inserted as current_timestamp() which is pretty common.
My system time is UTC +1.00 (BST) and I'm working with…

RetroRocker
- 53
- 7
1
vote
1 answer
perform function when video's current time is greater than a certain value
i would like to hide a div after a video has reached a certain time. The following code is what I thought would in theory work but is not currently. Any solution would be appreciated!

lucidigi
- 47
- 4
1
vote
1 answer
How to make file availabe to android app at exactly midnight respective to their time zone
I have a server configured to time zone IST which is GMT+5:30 and on everyday new JSON file will be generated using Cron job. Generated filename would be 1551139200000.json ie.GMT: Tuesday, February 26, 2019 12:00:00 AM.
How to make this file…

kiranking
- 306
- 11
- 29
1
vote
1 answer
PostgreSQL select now()::timestamp differs from default now()::timestamp
In my program every table has a column last_modified:
last_modified int8 DEFAULT (date_part('epoch'::text, now()::timestamp) * (1000)::double precision) NOT NULL
For update I added a trigger:
CREATE OR REPLACE FUNCTION sync_lastmodified() RETURNS…

valijon
- 1,304
- 2
- 20
- 35
1
vote
1 answer
JS currentTime in html video with php script for src don't working on Chrome
I am currently trying to modify the currentTime of an html5 video player that gets its source from a php script (headers method). the video is loading correctly and I have access to commands via JS:
I load the video via the php script into the html5…

Thomas
- 11
- 2
1
vote
1 answer
How can I change currenttime in htmlvideoelement element on Angular 6
I don't undestend how set current time for htmlvideoelement. I want change current time of video by click progress bar. Plase help me how it implament correctly. Might how know turnkey solutions.
html
1
vote
1 answer
How can System.currentTimeMillis return longs with different lengths in a short period of time?
I'm creating temporary directories with
Files.createTempDirectory(String.format("project-it-screenshots-%d",
System.currentTimeMillis())).toFile();
an I assumed that the longs returned by System.currentTimeMillis() all have the same length…

Kalle Richter
- 8,008
- 26
- 77
- 177
1
vote
1 answer
Store current timestamp in parquet using ParquetWriter
I am using following method to write data in parquet file :
static void toParquet() {
String schema = "message spark_schema {\n optional binary stringField (UTF8);\n optional INT96 createdAt;\n}";
MessageType readSchema =…

User_qwerty
- 375
- 1
- 2
- 10