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
0
votes
1answer
31 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
28 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
56 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
26 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
85 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
70 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
120 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
74 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
67 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
26 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
105 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
40 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 codes to domain descriptions. I ...
0
votes
1answer
108 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
136 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
317 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
42 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
176 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
133 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
58 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
0answers
206 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
347 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
133 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
396 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
285 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
29 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
114 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
454 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
129 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
85 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
58 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
38 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
39 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
41 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
104 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
196 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
318 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
104 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
97 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
382 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 ...
6
votes
1answer
2k views

Storing datetime values in Shapefiles using QGIS?

I have a shapefile with date in a string field. I create a new field with date type and use the calculator to make the conversion. But the result only provide the date part, the time part is removed. ...
4
votes
1answer
476 views

Date changed to strange values in feature class when uploaded to ArcGIS Online

I have a feature layer in ArcGIS Desktop running 10.1. It has a Date column with it. In ArcMap, this layer also has Time enabled with Time Zone set to "UTC+10:00 Canberra, Melbourne , Sydney" and "...
3
votes
1answer
480 views

How create a filter/pattern based on date and time interval between datapoints in QGIS?

I am working with a dataset of thousands of datapoints in QGIS. The datapoints are satellite pings that are usually taken each 2 hours. But for some reason there are some datapoints that are taken 1 ...
1
vote
1answer
138 views

Date output does not show “time” in ModelBuilder? [closed]

I have developed a Python script using ArcPy with one of the output variable being of Date type. In the actual Python code, the variable is a Python datetime object which has both the date and time ...
8
votes
1answer
870 views

Display full date-time, even when the time is 00:00:00

I have date fields in Oracle tables. When I view the data in the attribute window, the dates are displayed like this: 1/1/2017 1/2/2017 3:50:28 PM As demonstrated in #1, ArcMap doesn't show the ...
1
vote
1answer
450 views

ArcGIS Field Calculator Not Working With Date Field

I am trying to calculate a field based on the date values in another field. Here is my code from the pre-logic script code box: def getHalf(dfield): if dfield >= date '2017-08-27 00:00:00' AND ...
1
vote
1answer
1k views

Pulling week number from separate date column using Python and ArcPy for ArcGIS Pro?

I have a date field that contains date/time in the format DD:MM:YYYY HH:MM:SS. I want to be able to calculate the week number based on these dates in a seperate column using Python in ArcGIS Pro. I am ...
0
votes
1answer
258 views

Query Builder Expression using NOW () function

I have a date field named "TermDate'. I would like an expression in Query Builder to only show features where termination date is in the future. My date field displays as '2017-09-27 09:59:01' I'm ...
2
votes
2answers
228 views

Getting only time from Python parser of ArcGIS Field Calculator?

Using ArcGIS 10.4, how I can modify the Date() functions on VB or Python scripts of field Calculator Now ( ) datetime.datetime.now( ) to get only time like 12:32
1
vote
0answers
43 views

Working with year before 1900 and ArcGIS Space-Time Cube?

I am trying to create a space time cube for 10 years from 1870-1880, but I get this Error: ValueError: year=1873 is before 1900; the datetime strftime() methods require year >= 1900 I tried to ...
0
votes
1answer
637 views

Definition Query for records created in the past 30 days in and SQL SDE?

I am stumped as to how to get this to work in ArcMap... I have records being created ever day, and would like to be able to show records on a map that have been created within the last 2 days based ...