Stack Exchange Network

Stack Exchange network consists of 174 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
47 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
39 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
34 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
22 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
24 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
33 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
35 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
64 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
129 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
113 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
74 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
26 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
51 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
238 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
409 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
138 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
214 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
88 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 ...
0
votes
0answers
44 views

How to edit a range parameter?

I have a question concerning ArcGIS Pro. I've created a query layer in Model Builder that runs successfully, but when I replace where date_time between to_date('2017-06-30 00:00:00', 'YYYY-MM-DD HH24:...
8
votes
1answer
377 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
104 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
916 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
142 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
82 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
31 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
314 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
35 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
346 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
113 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
23 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
523 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
355 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
275 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
205 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
29 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
228 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
39 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
42 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
59 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
810 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
647 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
294 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
608 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
203 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
696 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
201 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 ...
7
votes
2answers
2k views

Making automatic updated date and time field in QGIS?

I want to make a date and time updated field as I edit an attribute field in this format yyyy-mm-dd 00:00:00 (= 2016-05-08 11:04:00) - my local date/time. The data is in a QGIS 2.14 shapefile and ...
0
votes
2answers
107 views

Incorrect data and time stamp

I am using the following select statement to enter the a record in a cartodb database. INSERT INTO catch ( site_code, have_catch, fishtype1, fishtype2, fishtype3, fishtype4, ...
1
vote
1answer
154 views

Passing where clause as variable to arcpy.SearchCursor() gives ERROR 999999?

I'm having trouble passing my where clause for arcpy.SearchCursor as a variable. The following code successfully generates a query for me: PolyList = "C:\\Users\\korora912\\Desktop\\polygons.shp" ...