Skip to main content
13,727 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
2 answers
95 views

We have got a table with a identifier, a key/value pairs and a start and end timestamp which indicates the valid period for the values. MASTER_WORK_ORDR_ID START_TS END_TS WORK_ORDR_ID_CTXT ...
L.P.'s user avatar
  • 3
1 vote
1 answer
166 views

I booked a train ticket with Trenitalia, the Italian train company. They sent an email with attached ICS files with the travel information. When I import that ICS in Thunderbird, the time of the train ...
robertspierre's user avatar
  • 5,379
0 votes
1 answer
127 views

I'm exporting some data from Snowflake to Rstudio and do some data processing. After that I write the data back to Snowflake. The problem is that somehow the timestamp initiale from Snowflake is ...
Quinten's user avatar
  • 42.8k
0 votes
1 answer
94 views

I need to append candlestick bars to Duckdb that have a timestamp data type. Since I don't know how I have used varchar for time instead. How do I do it properly so that I can query based on timestamp?...
lele1c's user avatar
  • 72
0 votes
0 answers
44 views

I need to copy timestamps (modified time) between NTFS reparse points of type junction, directory symlink and file symlink. I can get the timestamp of a reparse point with os.lstat(). But to apply ...
mcu's user avatar
  • 3,610
0 votes
0 answers
103 views

I am trying to write a program that modifies the timestamps of a lot of files at once. Doing this for aTime and mTime was straightforward using utimensat, but doing it for cTime and bTime/crTime it ...
princess.strelka's user avatar
  • 19
1 vote
0 answers
577 views

I wanted to store a timestamp from Python in a sqlite3 database. For that I used this kind of code from datetime import datetime, date, timedelta, time import sqlite3 import os def main(): ...
FredericP's user avatar
  • 1,129
1 vote
0 answers
29 views

I'm testing GridDB Community Edition 5.3 (Linux container via Docker Desktop on macOS 14.4, Apple M1). When I insert rows with millisecond timestamps into a time-series container, and query using a ...
Panuganti Jayanth Kumar's user avatar
  • 21
1 vote
0 answers
26 views

I'm using GridDB Cloud for a time-series application and working with the official Python client. I have a container named sensor_data that includes a created_at field of type TIMESTAMP. I want to run ...
Jamal Tiska's user avatar
  • 21
1 vote
1 answer
73 views

In a node.js application we manipulate dates and times as unix timestamps UTC (directly as numbers). These timestamps are stored in postgresql in timestamp columns (not using timezone because ...
Charles's user avatar
  • 155
-3 votes
1 answer
44 views

So, I am trying to manage multiple timezone in my nodejs project, I am unable to get results from mongodb timestamps according to timezone that user have selected. Need support to setup an enviorment ...
Haider Ali Mughal's user avatar
  • 1
0 votes
1 answer
83 views

Why does pd.to_datetime('2025175', format='%Y%W%w') and pd.Timestamp.fromisocalendar(2025, 17, 5) gives different output? I expected to obtain Timestamp('2025-04-25 00:00:00') for both cases. But the ...
viniciusrf1992's user avatar
  • 315
-1 votes
1 answer
50 views

I have found this Python function that converts my timestamp into an epoch: def str_to_timestamp(timestr, epoch=dt.datetime.fromtimestamp(0)): stamp = dt.datetime.strptime(timestr.strip()[0:20], '%...
KevP's user avatar
  • 21
1 vote
1 answer
115 views

I´m using Kafka Confluent to read from a SQL DB and covert the contents in JSON files to write them to a S3 bucket. My connector sink pattern is YYYY/MM/DD and the files are written properly to its ...
Alex's user avatar
  • 1,019
0 votes
0 answers
19 views

I have a set of geometric features that I want to animate (change colors) using Folium. I know how to do it (see MWE below), but it seems I need to copy the feature data for each time, only changing ...
Didac Busquets's user avatar
  • 645
0 votes
0 answers
178 views

Query Engine: Impala When we try to do a select query on a iceberg table which has TimestampNTZ column (Timestamp with timezone), it displays the results. But when I try to insert a value to the table ...
Ambarish Srinivasan's user avatar
  • 9
0 votes
0 answers
60 views

I am using Java 21 Spring Boot 3.4.2 and SpannerTemplate. I need to convert a field OffsetDateTime to the com.google.cloud.Timestamp for the TIMESTAMP column in the database. I tried implementing ...
Ebad's user avatar
  • 428
4 votes
0 answers
140 views

I'm having some issues using chrono after 2038. My system is a 32Bit system with the following configuration Kernel: 5.15.118 GCC: 13.2.0 GLIBC: 2.38 I have compiled my program with the flags ...
Ron's user avatar
  • 41
0 votes
1 answer
58 views

I am working on the Google Data Analytics Certificate and trying to clean a dataset consisting of 3 columns in BigQuery: An Id number A date in MM/DD/YYYY HH:MM:SS AM/PM format Number of calories ...
Ryelyn Desch's user avatar
  • 9
0 votes
1 answer
158 views

I'm developing an app that store some data with timestamp in the very-past. My JVM is IBM Semeru (17) running on Europe/Paris tz. But I want to store the timestamp at UTC (GMT+0). Bellow is my code: ...
SoT's user avatar
  • 1,267
0 votes
0 answers
35 views

I have a question. I recently noticed that the statuses aren't updating correctly from "new" to "active" and from "deleted" to "not visible anymore." For ...
B0K1NG's user avatar
  • 3
2 votes
1 answer
71 views

I have a dataset of messages being sent between two people (user A and user B) on different chats over time. I need to figure out how to track the datetime of the last but earliest user A message ...
rastrast's user avatar
  • 327
1 vote
1 answer
112 views

I'm trying to insert a the timestamp value March 9, 2025 at 2:35 am, but PostgreSQL silently changes it to 3:35 am. Here's the gist of what I'm doing: CREATE TABLE PATIENT (A TIMESTAMP WITHOUT TIME ...
Joe DiNottra's user avatar
  • 1,083
0 votes
2 answers
151 views

I am trying to figure out a way in VBA to give a timestamp when a cell is updated, but I want that timestamp to be static and only update one time, the first time. Columns A-I are a checklist and the ...
Starvsnr's user avatar
  • 3
0 votes
0 answers
61 views

My table has a TIMESTAMP column. Per our convention all times in the db is supposed to be in 'UTC'. When I insert a java.util.Date it is converted using the JVM's default TimeZone. There seems to be ...
Thomas Kiesling's user avatar
  • 41

1
2 3 4 5
…
275