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.

1
vote
2answers
20 views

Changing dd/mm/yyyy/ hh/mm/ss format to yyyymm in Hive

I'm using Hive at the moment. I have a column (column A) of strings which is in the following format 11/9/2009 0:00:00. I'd like to extract the yyyymm. i.e. I'd like the above string to be 200909. I'...
0
votes
0answers
14 views

Elasticsearch timestamp based queries over several daily-based indices

I am looking for examples with the syntax of different elasticsearch queries to get some selected fields from several daily-based indices (one index per day, for the last 30 days -> using ...
0
votes
0answers
33 views

How to write Swift Codable struct with Date property to Firestore

I fairly new to Firebase/Firestore and currently writing an iOS/Swift app to both write/read a Customer struct to the DB. The Customer has a validTill of type Date. At the moment, I can't seem to be ...
0
votes
0answers
25 views

How to display a custom weekly range of dates as the x-axis labels and aggregate the values accordingly in matplotlib?

The date type is: pandas._libs.tslibs.timestamps.Timestamp I am able to get the data in a weekly manner using groupby, but I was hoping the x-axis labels to include a customized date range such as 5-...
0
votes
0answers
12 views

How to read 'date last plotted'of an AutoCad dwg file without manually opening up the file?

I am trying to read the date last plotted timestamp inside of a dwg file. I don't want to open the file manually, but rather create a script that analyses the file. The reason for this is I'm going be ...
-2
votes
1answer
25 views

How can I delete minutes, seconds and microseconds from a timestamp value using Python?

For example, I have 1508265552 which is 10/17/2017 @ 6:39pm. I want to get 1508263200, which is same day but 6:00pm.For example, I have 1508265552 which is 10/17/2017 @ 6:39pm. I want to get ...
1
vote
1answer
19 views

How to change the timestamp security header in a wcf client?

I am trying to modify the default expiration time of the security header which is 5 min to 1 min. One of the security policies of the server is a timestamp (the date of the request), with a Time to ...
0
votes
0answers
25 views

Displaying exact/precise time-stamp on dataframe

I have a .csv file which is time-series data. However the dataframe time column truncates the time. How do I display the full time, to the nanosecond in a data frame? For instance, I want to go from:...
1
vote
2answers
40 views

Calculate seconds between 2 timestamps in R excluding weekends

If I have a dataframe with 2 columns which are YMD HMS, how do I calculate the difference in seconds between the two excluding weekends? col 2 - col 1 = time in seconds; need to exclude the weekend ...
0
votes
0answers
21 views

C# WebServicesClientProtocol wrong timestamp

I'm trying to create a WebServicesClientProtocol with a timestamp. currentService = new CurrentService() { Timeout = parameters.CallTimeoutInSeconds * 1000, ...
1
vote
2answers
32 views

Select data range from timestamp based on row.names

If I have a data frame and I wish to select a training set based on time range df <- data.frame(timestamp = seq(as.POSIXct('2013-08-02 12:00:00'), as.POSIXct('...
1
vote
2answers
23 views

Timestamp from firestore gets converted to a Map when using cloud function

So I have a Timestamp in cloud firestore. I am using cloud function to retrieve data from firestore to flutter. But JSON formats timestamp to map due to which I am not able to use it as timestamp. How ...
0
votes
1answer
24 views

PHP: Count the past hours / days

I've a timestamp in this format here: 2019-05-21 19:57:21 Now I want to display the hours / days that are past from this timestamp. For example when the timestamp is older than 2 minutes, I want to ...
0
votes
2answers
55 views

How to split all strings in a column of pandas dataframe?

I have a dataset with createdOnTimeZone and startDate columns. Timezones are like -600 but startDates are like 2019-01-28T19:50:27.345-06:00. I want to apply timezone to startDate in all rows. I know ...
1
vote
1answer
43 views

How to get difference between timestamps (either between strings or time.time) [duplicate]

I have one problem: I need to know the difference/duration between two timestamps in golang. Therefore, I use the time library (https://golang.org/pkg/time/). If I have two timestamps of type "time....
0
votes
0answers
9 views

JS - Given Timestamp Get UTC Offset For Time Zones Different From Local Zone [duplicate]

I have timestamps therefore indicating the UTC +0 time. I want to get the CT time related to those timestamps considering that the code can run from anywhere in the world. now I can simply add the -...
0
votes
1answer
35 views

How do I apply script to only one sheet

I need help tweaking the following code to apply to only one sheet in the workbook. I want to update column N when any cell in the row is modified starting at row 9. This works perfectly for me except ...
0
votes
0answers
26 views

difference btween multiple timestamps in pyspark

I have dataframe with user logins. They are loggin in multiple times in hour. For each window of 1 hour, I want to have the mean between delta of each login [Row(Day='2018-05-09', User='9999', ...
0
votes
1answer
25 views

Time stamp won't show in my contacts database

I am doing an online course , and I am trying to design a website with a user database . I have built a " Contact Us" page with a form/table . I cannot make the timestamps show in the rails console $...
0
votes
2answers
41 views

Union n amount of tables in mariadb and find the distinct value based on timestamp

I need to make a search on multiple database tables. Since all tables have the same structure(same columns, they are actually archived data for the same table) I can use UNION ALL to combine them all. ...
0
votes
0answers
25 views

How to add a date time column, with less values, into a separate data frame?

I have a df with two columns one contains a # representing a unique character and the other a date-time value. I want to pass the "date-time" values to a separate df with multiple entries of the same ...
-1
votes
0answers
9 views

How to check if two year ranges Overlap in Python?

I have a dictionary with a 'timestamp' as year range(Ex. 2016-2017) I need to check if one year range falls under another year range if it does I need to put some value of that dictionary into another....
3
votes
1answer
26 views

Python3 Panda's Holiday fails to NOT find dates in arbitrary periods in the past

Made my own definition of MLK Day Holiday that adheres not to when the holiday was first observed, but by when it was first observed by the NYSE. The NYSE first observed MLK day in January of 1998. ...
-1
votes
1answer
29 views

Why is join on dates + filter on timestamps faster than joining on time-range in Spark?

I have a dataframe X containing some events (points in time, with timestamps) and another dataframe Y containing time-ranges (also specified by timestamps.) Through experimentation and some reading I ...
0
votes
1answer
18 views

How can I set the default value of a timestamp field to a time in the future like 365 days from now?

In my files table, I have a column as scheduled_deletion_at which is a timestamp to define when a certain file should be removed from the environment. I want to set the default value for this column ...
0
votes
0answers
23 views

Comparing firestore timestamp with Date using datepicker in Kotlin

i'm working up in firestore, but get some problems with timestamp. i want to make a filter base on date using datepicker in android studio. i just want to comparing date of month and month. i think it ...
2
votes
2answers
20 views

changing of object into datetime format

I am currently working on google sheet by importing in python.When I import the sheet it was in object format and later I converted into float, but I try to change the format of Date column then it ...
2
votes
1answer
25 views

Add time in pandas beyond year 2262

I would like to add months to date in pandas. They may exceed beyond year 2262. There is a solution for relatively small number of months: import numpy as np import pandas as pd pd.Timestamp('2018-...
0
votes
1answer
20 views

what is difference between from_unixtime vs from_timestamp

Can someone please help to understand basic difference between date format functions available in Impala. Just to understand from_unixtime vs from_timestamp which one is betetter form_unixtime or ...
0
votes
0answers
22 views

Elastic Search Returning Time in Float instead of timestamp [duplicate]

I'm using a frame work (not made by me) that is using elastic search to save and retrieve data, this is my first time to use ES. When I save an updated_time as timestamp in ElasticSearch, postman ...
0
votes
1answer
23 views

Copy-Item by header & timestamp

I am using the code below to filter out files depending on the headers in the file. It works like a charm, but I have a problem with that it takes all the files in the $InputDirectory. I would like ...
0
votes
2answers
22 views

Column of type “Local Datetime” doesn't match with type “TIMESTAMP” in MySQL database

I'm experiencing an issue of type compatibility in MySQL version 5.6. I have this data formatted as Local Date time (2007-01-01T00:25:47) and I need to write them on database, but I cannot find a ...
0
votes
1answer
26 views

SQL - Get rows that has same created date datetime till minutes

I have a table with data like: id question_id Created_dt secondary_question_id -------------------------------------------------------- 1 71 2016-03-12 16:33:00 ...
0
votes
0answers
27 views

Logging accurate timestamps in a java multithread environment

How do i make sure that timestamps belonging to certain events are actually created and logged right at the same time that the event happened when multiple threads are running? class Thread1 extends ...
0
votes
1answer
27 views

Best way to match an incomplete searchString with a Date format within Java [duplicate]

I need to match a (partial) searchstring to a Date with timestamp from the database. I have a searchbox that allows you to search through 4 values at once. Those being: code, date, name and code2. ...
0
votes
2answers
44 views

How to extract first observation of the day in dataframe?

I have this dataframe containing a date column, and a unique ID. I would simply want to extract the first observation of each day. I tried to use the dpylr package (aggregate function) and date ...
-2
votes
1answer
63 views

Android - Convert a date into a Timestamp

I have a Date object that I want to convert it back to a Timestamp, the logic behind that is the user can input a event date and then that input gets converted to it's corresponding Timestamp and then ...
-4
votes
3answers
40 views

how can I convert a string '1:05" to a time stamp?

I need to add enroute time (1:05) to a depature time (which has been converted to a time stamp) to get the arrival time. how can I convert 1:05 to a time stamp?
0
votes
1answer
44 views

Google Sheet Auto time stamp

I'm trying to auto-populate a cells time ( cell B2 in sheet "leads") But doesn't seem to run the script successfully. Gives me the error "TypeError: Cannot read property "source" from undefined. (...
2
votes
2answers
18 views

Time Series: How can I adjust pd.date_range(freq='B') with the Saturday included. (Python)

This is my example code: q=pd.date_range('05/13/2019',periods=100, freq='B') Obviously, it would list out 100 the working days from 05/13/2019 with no Saturday and Sunday. However, in some Asia ...
-1
votes
0answers
19 views

C# - Convert Decimal (0.7489…) to DateTime [duplicate]

I have this value 0.74894675925925924 which I am reading from a Cell in Excel m_sheet.Cells[y, X].Value, but I am having a hard time transforming it to an actual time value which in this case is ...
0
votes
1answer
53 views

Extract data by day from SQL Server

I need to get all the values from a SQL Server database by day (24 hours). I have timestamps column in TestAllData table and I want to select the data which only corresponds to a specific day. For ...
0
votes
0answers
9 views

Filtering vimeo oEmbed to add timecoded

I am using a function to filter wp_oembed on my site that is allowing me to pass all the specified vimeo args through to my query but I want to add a timecode, and this isn't specified in the vimeo ...
0
votes
0answers
18 views

Swift Server side countdown timer is not exact on both my devices

I am programming an app using Swift 4 in which have a countdown timer with the end date timestamp value kept in my Firestore realtime cloud storage. For the current time, I don't want users to have ...
0
votes
0answers
12 views

Set time interval to Timestamp (x axis on graph)

I successfully managed to run the data logging web server for a sensor, but the X-axis on the graph keeps on logging because of the AJAX. I'm planning to shorten the X-axis to several seconds only and ...
0
votes
1answer
28 views

what does -753 mean in terms of timezone in `pd.Timestamp`

tz = pytz.timezone('America/Los_Angeles') t1 = pd.Timestamp(datetime.datetime(2019, 2, 6, 17, 0, 0, tzinfo=tz)) t1 Output: Timestamp('2019-02-06 17:00:00-0753', tz='America/Los_Angeles') Why -0753? ...
1
vote
0answers
26 views

Using timestamp for indexing a pandas data frame gives value error

I have a list of Timestamp called dates_list, which I want to use to extract values from another data frame df. However, df.loc[dates_list,:] >>ValueError: mixed datetimes and integers in ...
1
vote
1answer
27 views

How to find the timestamp difference between two files [duplicate]

When I execute ll command I get the timestamps: -rw-rw-r--+ 1 4167 May 5 17:19 file A -rw-rw-r--+ 1 2721 May 4 17:08 file B I want the difference between timestamps of A and B I tried ...
1
vote
1answer
38 views

HIVE:how to calculate seconds difference of time format: yyyyMMdd HH:mm:ss

How to calculate seconds difference of time format:yyyyMMdd HH:mm:ss? For example,calculate seconds difference of 20190102 00:01:05 and 20190102 02:14:18
0
votes
0answers
20 views

Convert Bytecode to Date

I have a Table with a column 'Date'. But the date is in Bytecode. Is there a way to convert it in a Timestamp? b'\x9d2\x9a\\x00\x00\x00\x00\x12\x01\x00\x00\x00\x00\x00\x00' b'x6\x9a\\x00\x00\x00\x00\...

http://mssss.yulina-kosm.ru