Questions tagged [timestamp]
A timestamp is the time at which an event is recorded by a computer system. The timestamp term may also refer to Unix Time or to the timestamp data type.
13,711
questions
0
votes
1
answer
17
views
Spark: cast timeStamp with date and time to DateType
Given the dateTime-value:
2021-02-12T16:21:22
I tried to cast it to DateType as following:
to_date(to_timestamp(col("Date"), "yyyy-MM-dd'T'HH:mm:ss"), "yyyy-MM-dd")
...
- 1,196
0
votes
0
answers
6
views
Is there a way to export the timestamp values of measurements in the Total Station?
I am using a total station model HI TARGET HTS-420R. I can export data in formats such as .csv, .dat, .dxf, .txt, .gsi. The data is exported as coordinate point name, x, y and z values (or e, n, z). I ...
- 1
0
votes
0
answers
43
views
pd.Timestamp() behavior in Pandas
Trying to understand why t1 takes current date whereas t2 takes the epoch date in Pandas in Python. Any thoughts would help.
import pandas as pd
t1 = pd.Timestamp("23:12:05")
print("t1:...
- 1,863
0
votes
0
answers
13
views
Datastage: loading csv file with timestamp with nanoseconds using schema file
I'm trying to load csv file with timestamp value like 2024-07-01 08:01:43.921000000 using schema file in Datastage.
I tried in schema file like below but it didn't work:
ZEITSTEMPEL_LETZT_GELOG_ANGEB:...
0
votes
1
answer
27
views
Confused by Linux File Times
I am writing some code to manage file times (atime, ctime, and mtime) for a LittleFS file system. In my desire to make this somewhat Linux/Posix like I ran into questions as to when these times are ...
- 5,423
0
votes
0
answers
15
views
forward-looking versus backward-looking timestamp conventions
I am collecting sensordata in a database. Observations are stored at an hourly or daily resolution, as timestamp - value. I have to deceide to make the timestamps
forward-looking (i.e 01/01/24 02:00 ...
- 125
0
votes
0
answers
31
views
Python command-line history with timestamps
Is there a way to record the time of each command? For example, hooking the interactive shell so that it writes the same content of ~/.python_history to ~/.python_history_timestamps but with ...
- 21
-2
votes
0
answers
55
views
Figure out time stamp format in SQL Server [closed]
I have inherited a project that has a SQL Server database. In one of the tables, an int column is defined and it should represent a date or maybe even a datetime. I have tried different methods of ...
- 317
0
votes
2
answers
65
views
Convert human readable time to epoch inline with jq for time comparison
I am writing a bash script to compare VM creation date to an epoch time gathered in a previous step to see what VMs were recreated before a certain date. These are bosh vms which gives human readable ...
- 65
0
votes
1
answer
26
views
RTC module current timestamp has truncated seconds
I have a simple bit of C (Arduino) code which uses a non-blocking interval timer to compare two different timestamp values to determine weather or not a specific interval x has passed, if so, then ...
0
votes
0
answers
27
views
Convert string to timestamp in pinescript
I'm importing a string that I then turn into an array. I would like to use the date and time values inside the array to draw lines from. The issue seems to be that a const string is expected. Is there ...
1
vote
2
answers
45
views
Remove rows if a certain value is reached, and recalculate
I have a dataset with GPS points and I want to remove points that are within a 2-hour period. Here's a sample of the dataset:
gps_data_animals_id acquisition_time
348179 348179 ...
- 391
0
votes
1
answer
32
views
pandas/python: Seperate Date and Timestamp and delete duplicates
I have a data set that date and timestamp of createddate and closeddate is in 1 column:
CreatedDate ClosedDate
1/1/2023 0:00 1/13/2023 12:43
1/1/2023 ...
0
votes
2
answers
26
views
How to configure javascript pg library to interpret timestamps without timezone as UTC timestamps when reading from postgres
My computer timezone offset is UTC/GMT +3 hours.
My table in database is defined as such.
CREATE TABLE public.order_invoices (
created_at timestamp NOT NULL,
updated_at timestamp NOT NULL,
...
- 194
0
votes
0
answers
15
views
Datetime format and time data not matching timestamp format errors in traceback log =
Traceback (most recent call last):
File "/usr/local/lib/python3.7/runpy.py", line 193, in \_run_module_as_main
"__main__", mod_spec)
File "/usr/local/lib/python3.7/runpy.py&...
- 1