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.

0
votes
1answer
26 views

How do I create document in Firestore with reliable timestamps?

How are any firestore timestamps considered valid coming from the client SDK when they can't be set on the firestore server itself? Is it not true that an authenticated user could hack his own ...
1
vote
1answer
18 views

Changing String into Time

I need to change String in D column(example 28/10/2018:01:51:29) into Time format. I've tried: Format cells and make my own formating(dd/mm/yyyy:hh:mm:ss) Data->Text to ...
0
votes
2answers
40 views

How to round up a timestamp to nearest 5 minute value

I have this format for a timestamp: 2019-01-24T00:00:05.011719 How do I round this up to the nearest 5 minute value? in perl Edit: Okay the question is pretty vague and lazy. But the question ...
0
votes
0answers
11 views

How to address moddatetime apparently bypassing precision of column?

We have a database where every timestamp is defined as timestamp(3) with time zone. We noticed that in some cases we were getting back timestamps with 6 fractional digits, not 3. I tracked this down ...
0
votes
1answer
22 views

VBA - Update timestamp when a row range is edited

I'm having some issues trying to put together a VBA code that will update a timestamp every time something in the row is edited. So what I need is a time stamp in A3 for when something from B3:CA3 is ...
0
votes
1answer
9 views

Lumen Carbon changing phpMyAdmin timestamp

I'm having a problem in using Lumen Carbon for my phpmyadmin created_at timestamp. Carbon is changing the time that is in my database that even setting default timezone for both php.ini, app.php on ...
3
votes
1answer
44 views

Join two datasets with closest timestamp interval

I need to join two dataset with the closet timestamp. The first datset is diary dataset from an mobile application: df1 <- data.frame(stringsAsFactors=FALSE, datetime = c("2019-03-...
0
votes
1answer
38 views

java.sql.Timestamp to Microseconds (Long with precision till Microseconds)

I have already looked at question from here and its solution, but looks like solution is from 2013 and I am looking for better solution than this. How to convert DateTime(TimeStamp) from Oracle to ...
0
votes
1answer
9 views

How to prevent Dataframe.to_dict() to generate timestamps

I am trying to use the python Dataframe to_dict() method without generating timestamps. My problem: I have a dataframe with cells containing dates such as this: "2019-06-01". When I call the dataframe ...
0
votes
0answers
22 views

Timestamp to Timestamp conversion with respect to Time Zone In java [duplicate]

I am converting Timestamp of One Zone to other Zone. I am getting the long value Same as what Source timestamp We are Giving. source Date--> originalDate=2019-01-09 12:00:42 IST, long value of ...
0
votes
1answer
18 views

Zip Archive - manually set the last modified on timestamp for the local and central headers

The customer we send our Zip Archives to requires the timestamps for all added file entries to be identical to the timestamp of the Zip Archive itself. In addition to individual entries local versus ...
0
votes
1answer
28 views

getting milliseconds out of AHK [yes, i know that has been asked before]

how do i add milliseconds to the AHK script below? i have been researching and can't find a way - or better yet, don't understand some of the solutions posted in SOF... nor do i know enough about any ...
0
votes
1answer
31 views

PyTables retrieve maximum and minimum values?

I've created a Python script which receives time-series data off a socket and writes it via PyTables to an HDF5 file like so: #Define description object to pass to the table constructor class ...
-2
votes
1answer
38 views

trying to convert timestamp to time with data type as int

Trying to convert timestamp to time with any zone using java, here I'm able to convert using ZoneID but it will return string data type. here I'm expecting output like getTimeMillis() Instant now = ...
-1
votes
1answer
18 views

Intervals timer from timestamp

I've found following simple script for timer from specific timestamp: var el ='.timer'; var start = 1553000000, cDisplay = $(el); var format = function (t) { var hours = Math.floor(t / 3600),...
1
vote
1answer
24 views

Is Kafka timestamp order corresponding to the offset?

We use kafka for our message queue,Our business required that message timestamp must with the same order with the offset, that means: if there are message m1 and message m2, and (m1.timestamp
-1
votes
1answer
34 views

Removing timestamp from date using INNERJOIN in SQL Server

I found a lot of things here, but nothing helped me. I can remove timestamp, but I can't remove it when I use INNER JOIN. I tried many things, but it does not work. Here it is what am I trying to do: ...
0
votes
0answers
14 views

isinstance(df, pd._libs.tslib.Timestamp) what does it do?

what does this function do exactly? here df is a dataframe with timestamp as index.For example, below DataFrame df: 2018-12-13 09:00:00, -113.0 2018-12-13 10:00:00, -112.5 2018-12-13 11:00:00, -114....
0
votes
0answers
18 views

how to get the minutes with decimals of seconds, javascript, timestamp?

I currently get the timestamp difference, this difference is understood to be the timestamp of a minute value. vm.horario_firebase = data.val() + Date.now(); let tiempo_faltante = ...
0
votes
1answer
32 views

How to replace current timestamp in SQL query

Here is my SQL query, I am trying to replace the current timestamp to past date, for e.g. CURRENT_TIMESTAMP to 16-03-2019 this date and see the output. SELECT p.ID, s.ID, p.SCREENCODE, p....
-1
votes
0answers
14 views

Why do we use touch command to touch an existing file that can change the file's creation time?

I understand it can change the file's access time and modify time, but I really could not understand it would change the file's creation time. This particular metadata is not supposed to change. ...
-1
votes
1answer
36 views

How to get current time in Scala in timestamp/datetime format so that it can be stored in PG table

I have written the following function in Scala which works: import java.text.SimpleDateFormat import java.util.{Calendar, Date} import java.util.{TimeZone, Date} val curr_timeFmt ="...
-1
votes
2answers
36 views

Generate timestamp for each ID in R in ascending order

I tried to generate timestamp in R for my data and I'm having problem to create them in order where each ID will take group of timestamp for the period of 14 days and I need to create them in ...
0
votes
1answer
26 views

How to retrieve data from firebase realtime database use timestamp?

this is my db structure : https://drive.google.com/open?id=15067yFPeeGoQH9kaagw6vxw-zoDFXmBN I want to retrieve data from the child "nilai" based on time using timestamp, then enter it into the ...
0
votes
2answers
31 views

Select data between night and day hours

My data looks like this, it is a minute based data for 2 years. 2017-04-02 00:00:00 2017-04-02 00:01:00 2017-04-02 00:02:00 2017-04-02 00:03:00 2017-04-02 00:04:00 .... 2017-04-02 23:59:00 ... ...
1
vote
3answers
45 views

Python getting hour from from timestamp

I need to classify timestamps based on the hour, for example if it is between 7 AM and 9 AM, it will be morning. I have timestamps that I take from my csv file and I need to get only hour so I can ...
0
votes
1answer
17 views

Datastudio + Bigquery Timestamp not working with Year - Week format

I have a timestamp column in query with format "2019-03-18 17:17:07.543200 UTC ", the default timestamp format for Bigquery standard SQL. When triying to plot a chart displaying the date as Year and ...
0
votes
1answer
23 views

Filter Pandas Dataframe with specific time of day or hour

I have a very large dataset : https://archive.ics.uci.edu/ml/datasets/individual+household+electric+power+consumption It contains around 2.5M rows. The Pandas dataframe index is a timestamp and then ...
-2
votes
2answers
50 views

How to generate TimeStamp of particular specific time

How can we generate TimeStamp of any particular selected time. Suppose I selected any date and time say "13/03/2019 01:11:14" so how can I generate the timestamp of that particular time.
0
votes
0answers
41 views

Cakephp: Time, diff not working as expected

I am building a task manager application where the user can start/stop a task. And I want to know when the user started it, when stopped it and how long task was running. In the appcontroller.php I ...
0
votes
1answer
24 views

ionic 4: Trying to display portion of Timestamp field but getting an error

I'm trying to display a timestamp on my ionic 4 html page but I am getting an error - here is the code within the html <ion-title> {{currentDetails?.date.seconds | date: 'dd-MM-yyy'}} </...
1
vote
2answers
32 views

Spark convert TimestampType to String of format yyyyMMddHHmm

In my dataframe I have a column of TimestampType format of '2019-03-16T16:54:42.968Z' I would like to convert this to a StringType column with a format of '201903161654' instead of a generic timestamp ...
1
vote
3answers
40 views

How to SELECT all rows within a certain date/time range with a certain timestamp step size in MySQL?

I have a table that contains sensor data with a column timestamp that holds the unix timestamp of the time the sensor measurement has been taken. Now I would like to SELECT all measurements within a ...
0
votes
1answer
13 views

Why can't I make a column with extracted months from the 'dates' column in my DataFrame? [duplicate]

I have a dataframe with dates, and I want to make a column with only the month of the corresponding date in each row. First, I converted my dates to ts objects like this: df['Date'] = pd.to_datetime(...
0
votes
0answers
7 views

CK Query into TableView which then filters by currentTime

After some expert guidance. I have designed an app which displays the departure time for trains on a narrow gauge railway. At the beginning of the day the database loads with all the trains due to ...
0
votes
0answers
19 views

Time formats for GPS Devices

Besides Unix and GPS are there any other timestamp formats that GPS devices use? I am trying to decode the timestamp sent by one of my GPS devices but I cannot understand what sort of data it is. It ...
0
votes
1answer
57 views

java.sql.Timestamp has a timezone [duplicate]

Everything I've read says a Timestamp is UTC and has no offset or timezone. However, I'mm 99% positive that the MS Sql Server JDBC is reading in the value from the DB and setting it in my local ...
0
votes
1answer
38 views

Insert timestamp based on specific criteria (Google Sheets/Script)

I'm trying to create a basic timestamp script. In short, I run some tasks that go through different status (status 1, 2, 3, etc). I want to track the timestamp of each status per task (row). I ...
0
votes
1answer
31 views

Convert timestamps without adding yyyy-mm-dd

I want to convert timestamps from characters to time but I do not want any date. On top of that, it must display milliseconds, as in "hh:mm:ss,os". If I use as.POSIXCT it always adds a date prefix to ...
1
vote
1answer
24 views

Insert missing rows in a specific time series

I have a specific time-series dataset which is as bellow. 0 2018-01-01 00:00:00+00:00 ... 1 2018-01-01 00:10:00+00:00 ... 2 ...
1
vote
1answer
33 views

Python delete all rows between the first view and the first click?

So I've been trying an failing and am hoping for some help. What I want to do is Group by users and sort by time stamp (which is the way the dataframe belowis set up) Now I want to take every view ...
0
votes
0answers
20 views

Problems service Add TimeStamp to CADES-T Sign

When I use the url of the TimeStamp service and I put it as an attribute within the CAdES-T signature. I used the following services: http://psis.catcert.net/psis/catcert/tsp (the answer comes with ...
1
vote
1answer
37 views

Flutter issue: type 'Timestamp' is not a subtype of type 'DateTime'

I'm looking for some help for an app my team and I are working on. We are facing the following problem for weeks : flutter type 'Timestamp' is not a subtype of type 'DateTime' We want to get these ...
0
votes
2answers
27 views

Jav8: Computing Elapsed time for Timestamp

I have the below code to get Current Timestamp and compute the Last Timestamp's elapsed time in minutes, am wondering if this can be optimized further for production public static Timestamp ...
0
votes
1answer
12 views

How to update mysql timestamp if a string in the same row has been updated?

There are 3 columns -> 'Name', 'Created', 'Last_Modified'. I would Last Modified to show the date if and only if the name has been modified. Each time the name is updated, Last Modified must be ...
0
votes
1answer
41 views

Decoding Dates from JSON (not iso type) - Swift, Decodable

I have a date (timestamp) passing through my JSON data that is not in iso8601 format. So, when I try to parse it I get a fatal error. I think I need to use some type of date formatting protocol but I ...
0
votes
1answer
26 views

dictionary counts timestamps wrong

So I have a list with timestamps, here are a few: lst_selected_uuid_timestamp= [datetime.datetime(2019, 1, 29, 15, 49, 33), datetime.datetime(2019, 1, 29, 15, 49, 36), datetime.datetime(2019, 1, ...
0
votes
1answer
15 views

how can i find values using timestamp in dataframe python

i try to find a value using timestamp like under data. date foo bar 2019-01-26 22:22:12 1 100 2018-11-07 13:12:26 1 100 2019-01-20 06:30:39 1 100 2018-11-05 21:...
0
votes
0answers
12 views

Coercing a timestamp with millisecond precision that's cast as a character into a recognizable date-time object in R

I have some timestamp values such as "2018-06-09 23:59:59.946" and "2018-06-09 23:59:59.938" that are being recognized as a character string in R at the moment and I need them to be treated as a date ...
-1
votes
2answers
38 views

pyspark check if HH:mm:ss is in a range

I have some data looks like this. time 08:28:24 22:20:54 12:59:38 21:46:07 I want to select the time that stand between 16:00:00 and 23:59:59, this is a closed range. What should i do with it? ('...

http://mssss.yulina-kosm.ru