Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

3
votes
1answer
81 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
0answers
22 views

Changing time in ArcMap

I am working with preciptation data (preciptation per day) in ArcMap. I have converted an .nc file to a NetCDF raster layer, but am not getting the dates as they are supposed to look like. Attached ...
0
votes
1answer
53 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
45 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
24 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 ...
0
votes
0answers
28 views

Converting string 24hr date/time field values into new field with just 12hr time as string using ArcPy in ArcGIS Pro?

Without explaining all my reasoning for why we need to do this, I need to take a field that our GPS units create called "CreationDateandTime" and use the values in there to create a new "UID" field ...
1
vote
1answer
46 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
102 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("...
1
vote
1answer
55 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 ...
1
vote
1answer
45 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
32 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
31 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
36 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
36 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
84 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
148 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
157 views

QQIS 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
83 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
57 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
284 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 ...
4
votes
1answer
657 views

Storing datetime values in Shapefiles?

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
215 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
268 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
104 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
508 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
172 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
169 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
128 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
35 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
372 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 ...
0
votes
0answers
57 views

Extracting Time from Date field [duplicate]

My data has a date field formatted as "MM/DD/YYY hh:mm:ss". I want to create a new field with just the time in the full "hh:mm:ss" format. I've found how to extract only the hour, only the minute, or ...
2
votes
1answer
504 views

Calculating field with hour from date time field with ArcPy?

This expression works in the field calculator to give me the hour from the datetime field called dtrepor arcpy.time.ParseDateTimeString(!dtrepor!).strftime('%H') But how do I call it in python? I ...
1
vote
1answer
135 views

Why doesn't animated show up as an option in Carto Builder Style Tab?

I'm trying to do a time series in carto. My data table has the following: -polygon geometry (geom) -polygon name (string) - eg State name -category (string) -date (datetime) Someone asked the ...
0
votes
1answer
25 views

Error when using variable in SQL clause with arcpy.MakeQueryTable_management

When I hard code a date my SQL query works fine where_week = "dtrepor > ‘2017-04-21 07:00:00’" but when I try to use a variable it booms out. This variable prints to the exact same date and time ...
3
votes
1answer
681 views

Datetime format in QGIS Points to Paths plugin

At 2.18.6, I am trying to use the PointstoPaths plugin. My input layer has a datetime string field with the following format: 2015-01-25 13:45:50 [Please note the blank between date and time.] ...
5
votes
1answer
459 views

Converting DateTime field to another time zone?

I'm using QGIS 2.16.3 and attempting to convert a number of datetime fields that are appearing in the incorrect default GMT +0 timezone. I would like to add, for example, 10 hours to accurately ...
5
votes
1answer
375 views

Color feature according to datetime field

I have a layer in QGIS which comes from a CSV with almost a million points. One of the columns of this csv is a datetime. I would like the color of the points to be on a gradient depending on this ...
1
vote
1answer
284 views

'infinity' PostgreSQL date/time input not showing in QGIS

I have a PostgreSQL table with a date-type column populated either with proper dates (e.g. 2016-01-01) or with PostgreSQL infinity date/time input. When I display the table in QGIS 2.14.11-1 (via DB ...
1
vote
1answer
30 views

Why are 12 hour time values printing as date values with ArcPy?

I have a field named ORIGDTTIME that contains 12 hour date values such as 06:36 AM. The field is a date data type in my feature class, however when I print the values from this field I am not ...
3
votes
0answers
294 views

Using date-string format conversion with ArcPy? [closed]

I have created a script tool that will ask a user to select start and end dates within which records will be selected from a feature class. The field containing the dates is formatted as type Date. I ...
3
votes
2answers
3k views

Calculate date field by adding 12 hours to existing date field

I am trying to convert the following code to python. DATE_VAL is a date field. I want to add 12 hours to the date. I have ArcGIS Desktop 10.4.1 and python 2.7.1. arcpy.CalculateField_management("...
1
vote
1answer
40 views

Finding closest time using ArcPy?

I have a time that indicates a ship was detected at a certain point. I want to go through a list of the tracks of ships in the area(id'ed by their mmsi) and find the closest time right before the ...
1
vote
1answer
46 views

join by minimum age from 1:n

For a gone experiment I want to link the weather data to recorded track points. The 3 layers envolved are the track layer (points), the layer of privat weather stations ("PWS" points) and a geometry-...
1
vote
1answer
69 views

Looping dates in a feature class comparing them to date 1 month from now in ArcPy?

I thought this would be quite a simple task but I'm struggling. I want to loop over a date field in feature class looking for dates 1 month from today. It appears that I'm running into a simple date ...
-1
votes
1answer
905 views

How to combine date and time in field calculator in arcgis

I want to simulate the travel path based on data points generated by my farm tractor, which is equipped a GPS receiver (I want to know where it starts and where it ends). Unfortunately the generated ...
1
vote
1answer
754 views

Automatically adding date to attribute table in ArcGIS 10.3.1 for Desktop?

I am using ArcGIS 10.3.1 for Desktop. I am working on a polygon layer in GDB file and i want that every feature that have been created in the map will be the date of creation (date and datetime). I ...
1
vote
1answer
356 views

Arcgis select by attribute the day of the week in date field

I am trying to select a specific day in the "Select by attributes" tool. I know you can select using a day from 0-31 like this: EXTRACT(DAY FROM "TimeStampStart") = 5 But I was wondering is there a ...
2
votes
3answers
690 views

Splitting a string field that contains time information

I have a text field within a FGBD that contains a date/time and I need only the time as a string. 'yyyymmdd HH:mm:ss' And I need: 'HH:mm:ss' I've tried .rsplit but I'm not using it correctly. I ...
2
votes
2answers
841 views

Convert string into date format problems

I have a string column within an attribute table that has a string in the format of: yyyyMMdd HH:mm:ss (i.e 20150417 13:32:05) I've tried using the convert time field tool within the python IDE in ...