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.

1
vote
1answer
30 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
21 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
23 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
38 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
65 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
48 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
41 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
28 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
27 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
34 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, "...
0
votes
2answers
71 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
143 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
137 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
79 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 ...
0
votes
0answers
28 views

Combining tracking data and space time cube using ArcGIS Desktop?

I have a problem with combining tram's route time data and space time cube in ArcGis. I have only data for a time interval from 6:00 AM to 10:00 AM of one day and when I try running the process, I get ...
3
votes
0answers
53 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
266 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
549 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
174 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
251 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
99 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
443 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
137 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
157 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
99 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
33 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
342 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
44 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
445 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
123 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
613 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
391 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 ...
4
votes
1answer
329 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
244 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
260 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
2k 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
45 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
61 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
876 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
699 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
326 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
658 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 ...
0
votes
0answers
223 views

Selecting only time in datetime field

I have a 'date' field (is a date field) in ArcGIS that contains both date and time: 'mm/dd/yyyy HH:mm:ss' and need to query only the time portion regardless of the date. I need times between >= 09:00:...
2
votes
2answers
771 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 ...
1
vote
0answers
213 views

QGIS Qt Designer set current date and time in mask

I have created an input mask for QGIS using the Qt Designer. Everything works fine but I have a small issue with the date, the time and the date/time edit widget. Is there any way to display the ...