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
1answer
62 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
42 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 ...
2
votes
1answer
30 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
42 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
34 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
39 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 = ...
0
votes
1answer
144 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
25 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
40 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
43 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
0answers
19 views

Aggregate precipitation by different time intervals at PIXEL level

I am trying to create a script to calculate the precipitation registered by GPM (Global Precipitation Measurements) between TWO dates. The challenge is that these two dates are defined by the Minimum ...
0
votes
1answer
122 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 ...
0
votes
1answer
175 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
75 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
32 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
175 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
77 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
239 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
128 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
111 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
34 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
1answer
213 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
43 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
142 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
187 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 ...
1
vote
1answer
496 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
46 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
372 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
142 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
60 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
373 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
607 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
186 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
449 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
417 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
33 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
148 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
513 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
156 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
115 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
63 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
56 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 ...
1
vote
1answer
40 views

Using field calculator unable to keep time and date format [duplicate]

I was looking to keep the date/time as is when using field calculator to keep the format as I'm not able to maintain the time in the new field "da". This is what I get when trying to do so. I tried ...
0
votes
2answers
44 views

Getting dates from an attribute table

I'm using the following to get a list of dates in a field called "EFF_DATE" from an attribute table for some pre-selected features. selectDates = [row[0] for row in arcpy.da.SearchCursor(selects, "...
-1
votes
2answers
116 views

How to iterate through date and time text file, line by line?

I am building a model on ArcGIS and I am now trying to iterate through a text file that contains in each line date and time information. I tried to do that on Model Builder, only I used the get field ...
2
votes
0answers
206 views

QGIS - Default Date Formats

I manage a fairly large estate of QGIS installs in the UK and am looking to set the default date formats to the uk dd/mm/yyyy format from our MSSQL data warehouse. Its set and works correctly in the ...
4
votes
0answers
389 views

QGIS Automatically Converts UTC Date-Time to Local?

I imported a WFS layer from a geoserver into QGIS and also into a web service that is based on Cesium. The geoserver fetches the data from Elastic search and serves it out as WFS. The date-time ...
2
votes
0answers
105 views

QGIS Date Time reverts back to 1950 after ~68 years

I have a column in a QGIS attribute table that contains elapsed time (in years). I have created an additional column in the attribute table to convert the elapsed time to a date. I am using an ...
3
votes
0answers
106 views

Writing Datetimes with Fortran in Shapefiles [duplicate]

I'm writing shapefiles nicely with Fortran. One of the fields I'm writing is a Date field. I read several things online that seem conflicting, wondering if I could get some clarification. The dBASE ...
0
votes
0answers
397 views

Raster Time Series, express years in time series

What's the best option to express years in Raster Time Series object in R. I define years as dates: YEARSSEQ <-seq(as.Date("2008-01-01"), as.Date("2009-01-01"), "year") and then I pass them in ...