Questions tagged [datetime]

datetime refers to a string that contains a date part and a time part, in that order. Typically it refers to a date and time encoded according to the International Organization for Standardization (ISO) 8601 standard: Data elements and interchange formats -- Information interchange -- Representation of dates and times.

Filter by
Sorted by
Tagged with
4
votes
3answers
121 views

Capturing Date using Date and Time from Expression builder

I have a string that includes date and time like in this format: '23/02/2021 09:03', '24/02/2021 09:10' etc. I would like to use Rule based filtering to colour symbols that has date=23/02/2021. So ...
2
votes
1answer
94 views

Convert time in float format to time format

I have a shapefile line layer with an attribute for time in float format. This is what 23.21 and 55 seconds looks like: 232155.17 This is 03.27 and 01 seconds: 32701.64 I would like to convert this ...
1
vote
1answer
53 views

ArcPy Select by attribute using create date

I'm writting a Python script that will look for newly created features and update them. This script will be automated to run every day at the end of the day. I'm using the Select by attribute tool to ...
0
votes
1answer
53 views

Converting excel integer date format to datetime using QGIS

How to convert Microsoft Excel date format to datetime format using QGIS? In example: 43089 in MS Excel is 2017-12-20.
1
vote
1answer
23 views

Calculating datetime difference using ArcPy [closed]

How would I calculate the time difference between two fields? For Example: 3/22/2018 7:08:00 AM - 3/22/2018 7:07:30 AM
0
votes
1answer
40 views

ArcPy - Get Date as parameter value and calculate Date field

In my ArcPy script I have an input parameter for the Date, so the user is asked to input a date value (time is not needed) using the data type GPDate. In the script I calculate a new field, field data ...
0
votes
1answer
31 views

Separating date and time from the same column into two columns

If I have date and time in the same column how can I separate them in two columns in ArcMap? And how can I put the date in this format (year,month,day)?
1
vote
1answer
30 views

Updating datefield from a string with UpdateCursor

I have a string I'm slicing and then using UpdateCursor to update rows with the outputs. The string is formatted like this: Foo_YYYYmmddHM_Xy_Ab_Bar I'm struggling in getting only the YYYYmmdd part of ...
1
vote
1answer
62 views

Error when trying to add system:time_start when using reduceRegions in Google Earth Engine

I am reducing an image collection into a feature collection by using a function to map the reduceRegions function to each image in a collection. I'm trying to make sure the system:time_start property ...
4
votes
1answer
378 views

Converting string column to datetime column in QGIS

I have an attribute column that has a string datetime and I want to convert that to a date column. I first attempted to simply add the time column in an expression, and I only got the year/month/date, ...
0
votes
1answer
142 views

GeoPandas dataframe from PostGIS table having date column

I have this PostgreSQL PostGIS database and I want to read this data in GeoPandas. I am able to create the GeoPandas database when I exclude the columns having dates/datetime #Reading data from ...
3
votes
1answer
40 views

Changing the time of a map label in QGIS using python

I would like to adjust the "[% format_date( now(),'dd/MM/yyyy HH:mm:ss') %]", as it currently displays 07/12/2020 13:31:40 on the map, as I am in the UK right now. However, I would like to ...
1
vote
1answer
47 views

Convert the time to the suitable format using Pandas [closed]

I have a file whose name is "MCD43A3_Alb_QA_SWIR_2020_061.tif", and I want to split the time "2020_061" and convert to the format "2020-03-01", how can I do that? Here is ...
1
vote
1answer
40 views

Selecting features by year in datetime field

I have a shapefile with a datetime field. I want to split the features by year and save into a geodatabase. My approach has been to create a list of years, and from there iterate over the list and ...
1
vote
1answer
86 views

Calculating dates and using arcpy.CalculateField_management(

I am in the process of converting my scripts from python 2.7 to 3.x I am trying to calculate a date field with a datetime object exactScriptTime = datetime.datetime.now() exactScriptTime = ...
1
vote
1answer
623 views

Setting Date and Time for QDateEdit and QTimeEdit

Working on a QGIS plugin, I am struggling to save/load date and time values. Users can enter dates via QDateEdit widget and times via QTimeEdit widget. Values are then stored the following: s = ...
2
votes
0answers
29 views

Time zone problem on a calculated field

I have configured a date/time field with the default value "now ()" on a shapefile. When I create an object in QGIS, the datetime is correct. In QField, there is a 2 hour lag. However, the ...
0
votes
1answer
88 views

Can't create fields of type Time on shapefile layers [duplicate]

I wanted to create new field in QGIS to store date and time from a datetime string field named dateposte. Here is the code I used to make it: import datetime layers = QgsProject.instance().mapLayers(...
1
vote
2answers
65 views

to_datetime in Python

I'm using QGIS 3.4 and I want to know how to convert a column datatype from string to datetime in python. I found that we can do that by to_datetime from the calculator but I want to do it from Python....
0
votes
1answer
245 views

Trouble with using Freemarker to formate Date for GeoServer GetFeatureInfo

I'm having some trouble while trying to use the Freemarker Template to display dates in the desired format. I store points with a date information in a PostGIS database written through an FME-process ...
1
vote
1answer
456 views

MODIS 'system:time_start' format problem in Google Earth Engine

In Google Earth Engine, what is the default format of time_start for MOD10A1 image?For example, var modisCollection = ee.ImageCollection('MODIS/006/MOD10A1') .filterDate('2000-08-21', '2001-02-28'...
2
votes
1answer
199 views

QGIS3: Import csv_file with DateTime Values

Has anyone managed to read in a "DateTime" value yet? I do not succeed, I always get text values. Test1 point_id,X,Y,ele,time,Ds,len "371",676239.6644,212505.7907,486,2020/04/07 09:58:07,0,0 "372"...
1
vote
0answers
46 views

Accessing bands of a NetCDF by datetime in Python

I want to write each band as a separate file (after gdal.Translate operation). So I can directly address to each band by datetime, not by a number? The second way, more sophisticated is to get all ...
1
vote
0answers
396 views

Using ArcGIS Pro to select all data collected "Yesterday" regardless of the time of day

I am using ArcGIS Pro 2.4.3. I can upgrade if needed. I am reading a hosted feature layer from my Organisation's AGOL site in ArcGIS Pro. This is using the standard Esri Data Store. This dataset ...
3
votes
1answer
106 views

Retaining subsecond time precision in date/time field in Geodatabase

I have a set of points (essentially tracks) with subsecond time precision, that would be useful to visualise/analyse. I have tried the "Convert Time Field" tool from string, float and double field ...
1
vote
1answer
440 views

Datefilter in leaflet.js

How do I filter data by date. If I want to filter, I can see the old filtering too. The layers are stacked on top of each other. How do I get the current date range. <div id="time-ranges" class="...
2
votes
1answer
334 views

Getting max() from list of dates using ArcPy [closed]

Using Python 3.6.8 I had the below portion of my script working previously on some test data, but now that I've tried to spool it up to the production data, it's not working. This is a snippet of a ...
1
vote
2answers
197 views

Handling, comparing, passing datetime variables with ArcPy

There are droves of questions on here about handling dates/times, and I've read through volumes of them, but still don't understand what I am doing wrong. I am trying to run a simple Python script in ...
0
votes
0answers
47 views

ArcGIS Select attributes X weeks before or after current date

I'm working on a project where the data gets updated every Monday (an XLSX file which I bring into a File Geodatabase and work with from there). I've been tasked with automating the data massaging. ...
0
votes
2answers
381 views

GeoServer Timestamp/Timezone error convert

Date format in PostgreSQL, -> 2019-10-30 08:46:44 Created WFS, but got a problem. GeoServer is converting the date. I think it somehow something with timezones. Output WFS -> 2019-10-30T07:46:44Z ...
0
votes
0answers
45 views

Select domain's last update date

I have tables in an Oracle 18c GDB that I integrate to a work order management system. I create views on the tables to translate the data. For example, I translate domain codes to domain descriptions. ...
0
votes
1answer
203 views

Editor Tracking: What is the mechanism behind this functionality?

I have Editor Tracking enabled on a table in an Oracle enterprise geodatabase (versioned): Tracking an editor's changes to data says: ArcGIS automatically records new editor tracking values ...
0
votes
1answer
256 views

ArcMap ModelBuilder Date query in line substition

I have successfully created the Minimum date and time variable as well as the maximum date and time variable(date datatype). I am only looking 30 seconds in either direction from the record I am ...
2
votes
1answer
798 views

Calculate date difference (days) with expressions (QGIS)

I would like to calculate the number of days between two dates. The first date is written in attribute table [YYYY-MM-DD] (creation date) and the second is today [now()]. The goal is, to get the age ...
1
vote
2answers
57 views

Adding time to variable using Python Parser of ArcGIS Calculate Value tool?

I am using Python 2.7 in calculate value in ModelBuilder. I want to query both 30 seconds before and after the variable. The original value keeps returning not the time change. What am I not defining? ...
0
votes
0answers
612 views

Set property (date) of images in Imagecollection from value in date band in Earth Engine

I have a Imagecollection with 2 bands per image. One is the 'date' band. The pixel values from this band are equal in every image. The value of one of the pixels i want to use to add as date to the ...
3
votes
1answer
151 views

Visualizing business operation time (opening/closing) over course of week in QGIS?

I'm pretty new to QGIS3.4 and I would like to ask how could I visualize the business operation time (opening/closing) over the course of a week. I know that I could input an time in the data ...
1
vote
0answers
65 views

Datetime on attribute tables

I have written a script to add, among other stuff, a datetime column. I have used the arcpy.AddField_managementcommand, but it didn't have a 'Datetime' type, so I used the 'Date' type : arcpy....
0
votes
1answer
716 views

Changing date format for labels in ArcGis Pro with label expression?

I am trying to use an expression to convert my date field to a simple %d,%b,%Y format. Right now it is in "%Y%m%d %H:%M:%S %z" How do I do it properly using Python to do this in ArcGIS Pro? Q&...
1
vote
1answer
941 views

Add date and time to attribute table using ArcPy insertcursor

ArcPy under ArcGIS Pro 2.3.2. I am adding a Python datetime.datetime object to a shapefile attribute table using an arcpy insert cursor. The problem is that when I add the datetime instance, the date ...
4
votes
1answer
205 views

QGIS: Select point(s) in other layer with similar datetime value from selection

For the interpretation of bird observations, I need to identify the position on a GPS-track (gpx-files), from which the position of a bird observation (other gpx-waypoint layer) was recorded. The ...
0
votes
1answer
553 views

Show time series data with non-contiguous times using Leaflet TimeDimension plugin

My data is made up of squares forming a grid where the value of each square changes with time. The times are equally spaced with 1 hour intervals, however, the data is only available for a certain ...
1
vote
1answer
578 views

WFS: how to do relative dates?

How would you query a WFS using relative dates/ranges in a single URL call? For example, I can do this: https://my.server/geoserver/ows?service=WFS&version=2.0.0&request=GetFeature&...
1
vote
0answers
37 views

Handling UK Date/Time Format for Animation in ArcGIS

I am attempting to make a time animation in ArcGIS of measured field data across a continuous sequence of 1Hz spatial sampling. My data are a series of XY points with assigned datetime, lat, long ...
1
vote
1answer
171 views

Measuring Distances between Points with the same timestamps using QGIS

I'm facing the problem that I want to calculate flight distances of Red Deer. I have a Layer with point Locations of animals; One attribute is the timestamp. I have another layer with point locations ...
1
vote
1answer
592 views

Plot trajectory in R

Does anyone knows a library/technique in R where you can plot a trajectory using multiple timesteps (points) where each point does have a lat/lon coordinate? I have this data x <- read.table("...
2
votes
1answer
188 views

LiDAR data in GPS time, only in second. Missing week?

I have LiDAR data LiDAR Data captured, unsure what units or format this time field is in? which I learned that my LiDAR data is in GPS second, however I do not have a column of data which shows the ...
3
votes
1answer
190 views

LiDAR Data captured, unsure what units or format this time field is in?

I haven't been able to figure out or find out from searching around what units or format this time field is in my LiDAR data that was collected?
2
votes
0answers
76 views

ArcMap Date values lose precision after copying feature class from fGDB to SDE GDB

I have some data in a file geodatabase feature class including some date fields. The precision on the date fields is to milliseconds and this is important. When I copythe feature class from the fGDB ...
0
votes
2answers
73 views

Re-arranging date to mm/dd/yyyy and skipping empty cells in ArcMap using ArcPy cursor?

I'm trying to get my code to re-arrange existing dates in the cell to mm/dd/yyyy and skip empty cells. I thought by putting if None: continue would work but it's not. Any tips? Here is my code and ...