13,724 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
3
votes
2
answers
112
views
pd.Timestamp has attribute .isoformat, but the series accessor .dt does not
I am trying to convert a column of pd.Timestamp objects into a columns of type str where the dates are encoded in ISO format.
The class pd.Timestamp has the handy classmethod .isoformat() that does ...
Best practices
3
votes
4
replies
111
views
PostgreSQL: Should I store timestamps as UNIX epoch or timestamptz?
I'm dealing with a timezone issue in a PostgreSQL project and would like some advice.
I'm currently choosing between two ways to store timestamps:
1. UNIX timestamp (bigint)
Very safe in terms of ...
11
votes
2
answers
749
views
Retain the exact modification timestamp of a file in a Git repository
I'm trying to persist the last modification timestamp of a set of files in a Git repository. I understand that Git doesn't natively support tracking filesystem metadata, so some sort of customization ...
0
votes
2
answers
132
views
Grouping of records in case values are null
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
...
1
vote
0
answers
102
views
Why is the ServerValue.TIMESTAMP Realtime Database writing with such a large offset?
I'm implementing an online presence feature in an Android app, recording a heartbeat periodically while the client is active. I'm using RTDB timestamp for this. But the recorded data is on the order ...
1
vote
1
answer
180
views
Is it standard compliant to declare DTSTART without time zone?
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 ...
1
vote
1
answer
39
views
How to prefix a specific series of lines (multiple)?
I have a text file, which has an inconsistent timestamp format, that I would like to standardize. This is in a transcript from an interview; ultimately for textual analysis.
What command could I run ...
0
votes
1
answer
135
views
Import timestamp from Rstudio to Snowflake changes timezone
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 ...
0
votes
1
answer
47
views
GridDB Python client inserting datetime object into TIMESTAMP column
I’m using GridDB Cloud (Free Tier) with the official Python client (latest pip release) on Ubuntu 22.04.
My container schema looks like this:
device_id STRING,
created_at TIMESTAMP,
temperature DOUBLE
...
0
votes
1
answer
115
views
How do I append a timestamp data type with zuckdb/duckdb appender in zig
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?...
3
votes
2
answers
113
views
How to cast a timestamp to date in format YYYY-MM-DD in griddb
I created a collection container name ‘orders’ with the below DDL using NewSQL Interface:
CREATE TABLE orders
(
orderId STRING PRIMARY KEY,
customerId STRING,
orderDate TIMESTAMP,
...
0
votes
0
answers
50
views
Modifying timestamps on Windows reparse points
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 ...
1
vote
0
answers
111
views
Robocopy algorithm for /FFT and /DST options
Microsoft's Robocopy program has these two options:
/FFT :: assume FAT File Times (2-second granularity).
/DST :: compensate for one-hour DST time differences.
What is the exact algorithm that ...
0
votes
0
answers
118
views
How do I set data in an Inode Field using C
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 ...
-3
votes
1
answer
190
views
How to configure ObjectMapper to deserialize java.sql.Timestamp?
I am facing an issue with configuring the Jackson ObjectMapper to deserialize java.sql.Timestamp.
In particular, the issue is that deserialization with a mapper that was initialized via ObjectMapper ...