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,708
questions
-2
votes
0
answers
28
views
Figure out time stamp format in SQL Server
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
0
answers
21
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
12
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
41
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
25
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
0
votes
1
answer
46
views
Bigquery error about unable to cast timestamp string to a timestamp when trying to insert it
I am trying to insert this timestamp "2024-07-02T10:46:58.108707769" into a TIMESTAMP column in bigquery, but I get the error Query error: Could not cast literal "2024-07-02T10:46:58....
- 480
0
votes
1
answer
28
views
How to add timezone and day light saving info into google protobuf Timestamp?
I'm using google protobuf timestamp for recording purpose in python, however, when I compare the timestamp, I would need to know the timezone and day light saving information associated with every ...
- 341
0
votes
0
answers
18
views
Is it possible to partition an Athena table using a variable which is timestamp datatype
I am trying to partition an athena table by a timestamp variable called 'forecast_datetime'. To use this variable as a partition I have made it 'string', with following values:
'2007-12-10-11-00-00', '...
- 585
-1
votes
1
answer
34
views
Hour and Minutes Timestamp in Pine Script
I tried to create candle's "hour and minutes" timestamp in Tradingview pine script. I could create hour timestamp but not minutes next to it. Can someone fix this problem?
//Time Stamp
...
-1
votes
1
answer
59
views
os.clock() in lua return wrong value
I'm using os.clock in lua to measure working time of a function. I add debug log like below
test = function()
print(">>>>>>>>start record id: ", record_id, "...
0
votes
0
answers
20
views
eBay Digital Signatures header 215113 error Invalid timestamp in signature parameters
I am trying to create digital signature for Ebay API. I always get error 215113 "Invalid timestamp in signature parameters". I am using long timestamp = DateTimeOffset.UtcNow....
1
vote
1
answer
51
views
Excel statement that updates only once
I have one cell that indicates the status of a project. And then multiple other columns that are intended to mark the date of when the project changes status.
Status
Date Project New
Date Project ...
- 11
0
votes
0
answers
11
views
Efficiently Synchronizing Put/Call Ratios for Identical Contracts in a Tokio-based, Rust Quantitative Backtesting System
I am enhancing an event-driven quantitative backtesting system in Rust, which utilizes Tokio for asynchronous operations. The system's design involves multiple traders managed within a single ...
- 147