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
1 vote
1 answer
22 views

QGIS TimeManager returning zero records

I am using QGIS 3.26 and TimeManager 3.6 and have imported a GPX file with ~10000 times in a qDateTime field called "time". Viewing the label and attribute table show these appear to be ...
  • 121
2 votes
1 answer
25 views

ArcGIS Pro 3 Create year, month and day columns

Based on the sample data column below, what tool I can use in ArcGIS Pro 3 to create the Year, Month and Day columns in the attribute table? The purpose is to then use these columns to create a space ...
-2 votes
1 answer
36 views

Time difference between two string fields with microsecond (or seconds) resolution using, Arcpy, datatime and UpdateCursor

I am trying to calculate (using Arcpy) the time difference between two fields that are in string data type and they have the following time format "YYY-MM-DD HH:mm:SS.sss" I have achieved ...
1 vote
1 answer
31 views

Get specific rasters (with date string in rasternames) from FGDB in to the list

I have a FGDB with many rasters. The raster name contains date at the end(YYYYMMDD). See example rasters bellow. I can get all rasters in to the list with wildcard. That is not the issue. I want to ...
  • 91
1 vote
1 answer
24 views

Earth Engine: how to access the dates from a list retrieved from an image collection

I have implemented the answer of Noel Gorelick to the question: Earth Engine get dates from imageCollection It is the following code: var dates = s1_collection_f .map(function(image) { ...
3 votes
1 answer
101 views

Changing appearence of DateTime input in QGIS Processing tool to international datetime format

I am writing a processing tool for QGIS where I use a QgsProcessingParameterDateTime as input. By default it displays the input in a not understandable format (dd.MM.yy HH:mm). To keep this input ...
  • 27.2k
6 votes
0 answers
47 views

Exporting Geopackage converts milliseconds of QDateTime to zero

I use this solution to display actual QDateTime value with milliseconds in a temporary memory layer. And I use another solution to export as CSV the value including the millisecond value. But then, I ...
1 vote
1 answer
392 views

Date label on a Sentinel-2 image collection (Google Earth Engine)

I found a way to add text to the images of a collection using a package that GEE user Gena created for this purpose. I used this code as guide, in the addText function I used the property system:...
3 votes
1 answer
82 views

Exporting layer with datetime field with milliseconds value

I have a layer with datetime field with milliseconds. I use the following script to get a QDateTime object and add it to a memory layer: layer = QgsVectorLayer("Point?crs=EPSG:4326", "...
6 votes
1 answer
100 views

Displaying milliseconds in Attribute Table using PyQGIS

I have a datetime string with microsecond. I use the following script to get a QDateTime object and add it to a memory layer: layer = QgsVectorLayer("Point?crs=EPSG:4326", "test", &...
1 vote
0 answers
39 views

Auto update date-time in QGIS

In QGIS 3.10 I need something to auto update a datetime attribute. I need it to update only when any other attribute is updated. I have tried the following: Steps: Add a Edited Date Field (ESRI uses ...
  • 11
0 votes
0 answers
71 views

ArcGIS API for JavaScript 4.23 : Cannot use SQL CAST function with layer.definitionExpression but it work fine with query builder

I'm working with features which needs to be filtered. I need to use the definition expression : https://developers.arcgis.com/javascript/latest/api-reference/esri-layers-SceneLayer.html#definition... ...
  • 71
1 vote
1 answer
54 views

Check if one date before or after another date in Google Earth Engine

How do I check if one date is before or after another date using the Google Earth Engine Python API? In other words, I want to compare two dates like datetime object in Python. import ee firstDate=ee....
  • 181
2 votes
0 answers
58 views

QGIS 3.16 Use change state of a checkbox as a trigger for updating another field

I want to record the date/time of field survey for features. This should only be updated at the moment a checkbox value is ticked. Further edits would be needed to the record later, either in the ...
2 votes
1 answer
52 views

Date operation in the Query Builder withPostGIS layer

I would like to filter a PostGIS layer by a datetime (QDateTime) field. I only want to show elements newer then 14 days. I tried the following expression in the Quary Builder: (day(now() - "...
  • 23
0 votes
1 answer
76 views

How to filter two time periods in a year?

Well, if I want filter to two time periods in a year. Just like 1989-01-01~1989-04-01 and 1989-10-01~1990-01-01.It is about the time series analysis. There is part of my code, something not shows ...
0 votes
0 answers
46 views

How to convert UTC in LMT with field calculator in QGIS?

I have GPS data in shape format in QGIS. But in my attribute table only the UTC time is given in the form of 01.01.2022 05:00. Is it possible to add a new column with the field calculator where I can ...
  • 39
7 votes
3 answers
244 views

Selecting latest record by date

At 3.22.1 I have a GeoPackage attribute table containing the string field: box_id and the date field: inspection_date. The table rows look like: box_id         inspection_date NE_01_01    2021-05-01 ...
  • 7,080
0 votes
1 answer
92 views

SQL expression ArcPy date format

I'm trying to use definitionquery to keep entities where date is smaller or equal to a certain date ( variable entered by the user). The Variable and the field in the table are formatted as dates. ...
  • 37
0 votes
1 answer
52 views

ArcPy select analysis date field > date variable

I am sure this is probably a simple syntax fix but I receive invalid syntax errors during the Select Analysis when trying to select records where the date field in my file geodb (ISS_CST) is greater ...
  • 479
3 votes
3 answers
327 views

Removing the time zone from datetime field in QGIS

How can I get rid of the time zone in the date/time field? So I have a GeoPackage with the following data: and want to get just 2021-06-07 16:25:40
3 votes
1 answer
54 views

QGIS attributes table shows wrong data when printing Timestamp with Milliseconds

I'm using QGIS to Debug Geometries and corresponding times. For that, I created GeoJSON in C# and added 3 timestamps as attributes: feature.Properties.Add("CreatedUTC", CreatedUTC.ToString(&...
0 votes
2 answers
289 views

Customizing DateTime field in ArcPy data management feature

I have a table in SQL with one column TIMESTAMP which shows the date/time in the following format. 2019-05-31 08:09:20.000 In order to process the data in ArcGIS, I created a new table in ArcGIS. To ...
  • 57
1 vote
0 answers
118 views

Datetime in ArcGIS Pro defaults to 12/30/1899

I have datetime field in a CSV with the following format: Time 2007-02-01 05:00:00+00:00 When I use the append tool in ArcGIS Pro to load data to a table on a SQL Server Enterprise geodatabase, ...
3 votes
1 answer
3k views

Parsing/converting ISO 8601 datetime fields using pandas

I have a datetime field in a Pandas dataframe that becomes problematic when using ArcGIS Pro to load data from a csv to a table on ArcSDE. The field in Pandas looks like this: 2007-02-01T05:00:00....
4 votes
3 answers
245 views

Capturing Date using Date and Time from Expression builder

I have a string that includes date and time like in this format: '23/02/2021 09:03', '24/02/2021 09:10' etc. I would like to use Rule based filtering to colour symbols that has date=23/02/2021. So ...
  • 175
2 votes
1 answer
374 views

Convert time in float format to time format

I have a shapefile line layer with an attribute for time in float format. This is what 23.21 and 55 seconds looks like: 232155.17 This is 03.27 and 01 seconds: 32701.64 I would like to convert this ...
1 vote
1 answer
205 views

ArcPy Select by attribute using create date

I'm writting a Python script that will look for newly created features and update them. This script will be automated to run every day at the end of the day. I'm using the Select by attribute tool to ...
  • 335
0 votes
1 answer
231 views

Converting excel integer date format to datetime using QGIS

How to convert Microsoft Excel date format to datetime format using QGIS? In example: 43089 in MS Excel is 2017-12-20.
  • 5,732
1 vote
1 answer
47 views

Calculating datetime difference using ArcPy [closed]

How would I calculate the time difference between two fields? For Example: 3/22/2018 7:08:00 AM - 3/22/2018 7:07:30 AM
  • 21
0 votes
1 answer
156 views

ArcPy - Get Date as parameter value and calculate Date field

In my ArcPy script I have an input parameter for the Date, so the user is asked to input a date value (time is not needed) using the data type GPDate. In the script I calculate a new field, field data ...
0 votes
1 answer
114 views

Separating date and time from the same column into two columns

If I have date and time in the same column how can I separate them in two columns in ArcMap? And how can I put the date in this format (year,month,day)?
  • 1
1 vote
1 answer
96 views

Updating datefield from a string with UpdateCursor

I have a string I'm slicing and then using UpdateCursor to update rows with the outputs. The string is formatted like this: Foo_YYYYmmddHM_Xy_Ab_Bar I'm struggling in getting only the YYYYmmdd part of ...
  • 383
1 vote
1 answer
319 views

Error when trying to add system:time_start when using reduceRegions in Google Earth Engine

I am reducing an image collection into a feature collection by using a function to map the reduceRegions function to each image in a collection. I'm trying to make sure the system:time_start property ...
4 votes
1 answer
1k 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, ...
  • 41
0 votes
1 answer
301 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 ...
3 votes
1 answer
72 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 ...
  • 183
1 vote
1 answer
52 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 ...
  • 51
1 vote
1 answer
65 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 ...
  • 383
1 vote
1 answer
265 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 = ...
  • 2,114
2 votes
1 answer
1k 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 = ...
  • 27.2k
2 votes
0 answers
56 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 ...
  • 21
0 votes
1 answer
231 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(...
  • 245
1 vote
2 answers
117 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....
  • 245
0 votes
1 answer
515 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 ...
2 votes
1 answer
865 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')...
  • 109
2 votes
1 answer
504 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"...
  • 23
1 vote
0 answers
73 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
0 answers
706 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 ...
  • 2,088
3 votes
1 answer
151 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 ...
  • 39