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.
159 questions
2
votes
1
answer
87
views
Getting layer last modified value with QGIS Expression
I am working on some revision tracking and would like to present information about when layers saved in a GeoPackage were last edited using an expression. I can create a custom function if necessary.
...
- 2,002
0
votes
0
answers
26
views
Missing timestamp information exported GEE .tif file
I am trying to export GEOS-CF information to my google drive. This works, however I do not see any associated timestamp information in the metadata using python or ArcGIS. This is supposed to be Temp, ...
0
votes
1
answer
91
views
Google Earth Engine - Filter Sentinel 1 by time not date
So I'm trying to filter sentinel-1 data in Google Earth Engine by time specifically rather than date. I'm trying to avoid morning acquisitions.
So I know that the acquisition start time is contained ...
- 147
4
votes
1
answer
174
views
QGIS can't create layers with DateTime with UTC data
I was creating a geopackage of points with a DateTime field, and the QGIS (version 3.32.3-Lima) seems to treat it as naive localtime data.
Layer/CreateLayer/NewGeopackageLayer:
Layer properties/...
- 1,724
0
votes
0
answers
17
views
Get specific range of dates when flood value is low in GEE Sentinel-1
I am new at GEE and I am trying to do some flood analysis, I already have a time series of flood for one point, I did it getting the value from VV band of sentinel-1. Now I want to get the range of ...
0
votes
1
answer
81
views
Datetime from attributetable to layername in QGIS with Python
I have several (point) layers and I want for all of them this >
Take the first value of the "datetime" column and append it on the layername.
These point layers come from gpx track ...
- 17
3
votes
1
answer
365
views
Convert string date time to datetime in QGIS
I am trying to convert a string column that contains date and time values into a datetime column in QGIS. The format of the string column is (yyyy-mm-dd hh:mm:ss). I write the expression as ...
- 33
1
vote
1
answer
207
views
Changing field type from string to time in QGIS
I have a file with arrival and departure times for public transport in the format XX:XX:XX and field type Text(string). I need to be able to sort it from smallest to largest (i.e. earliest to latest ...
- 311
4
votes
1
answer
349
views
Converting text date to numbers date using QGIS Field Calculator
I have a shapefile with polygons. Each polygon contains a date (fully written in text, for example: '2 june 2018') in the attribute table. This field is format 'text'. Now, I would like to convert ...
- 107
0
votes
1
answer
250
views
Datetime conversion exception with GeoServer and MySQL plugin 2.23.2
After recently upgrading my database server from MySQL 5.7 to 8.0.31, I have updated the GeoServer in my project with the latest version 2.23.2 and the corresponding MySQL connector.
After this I got ...
- 111
2
votes
0
answers
49
views
QGIS Time error: UTC = Australian Central Standard Time
QGIS version 3.26.3-Buenos Aires
Ubuntu 20.04.6 LTS
I originally made a GPS waypoint approx lunch time in central Australia.
In QGIS I import a gpx file with waypoint
<time>2023-04-23T01:12:40Z&...
- 61
1
vote
1
answer
127
views
Filtering string column with datetime in PyQGIS
I have a CSV in QGIS and one of the columns is "Data/Hora GPS" with the DateTime in format (day/month/year hour:minute:second), in the field calculator I used the expression for filter:
...
- 99
3
votes
1
answer
61
views
QGIS Extract by Expression - Only subgroups w/ time duration between consecutive observations < 4h
I have several point layers with the attributes CLUSTER_ID (groups points in different clusters by unique ID) and datetime_lcl (timestamps). In each layer, I'd like to extract only the clusters in ...
5
votes
1
answer
370
views
Calculating the day of the year with QGIS expressions
At QGIS 3.28.6 I have an attribute table containing a datetime field from which I need to populate an integer field that will contain the day of year (for example, 2/1/2018 would output to 32).
Using ...
- 8,356
0
votes
1
answer
356
views
Merge Date and Time Columns to a combined Date Column
So my dataset has two columns, Date (type Date) and Time (type Text) as shown in the screenshot below. Now, I would like to merge the two together and then create a new date column using the "Add ...
- 1,244
2
votes
1
answer
306
views
Enabling time field in ModelBuilder of ArcGIS Pro
Does anyone know how to enable a time field in the ModelBuilder of ArcGIS Pro?
I am attempting to create a model that takes a newly created feature class and runs "Group By Proximity", which ...
- 33
2
votes
0
answers
154
views
Detecting break point in Sentinel-2 time series [closed]
I am trying to create a simple method for wildfire detection using Sentinel-2 time series via GEE. The method is based on the decrease of the Normalized Burned Area (NBR) Index when a fire occurs.
So ...
- 1,044
2
votes
2
answers
159
views
How to generate sequential date field by year?
Looked at several similar questions but cannot find solution.
I'm working with some mosaic rasters that need a date fields added to them for a time dimension, but I don't want to do it manually. I've ...
- 33
0
votes
2
answers
448
views
Converting antiquated string date values to datetime values in ArcGIS Pro [closed]
I am trying to modernize an existing parcel data set that stores date information as strings in the following format: "YYYY MMM DD" 12/13/2022 would be stored as "2022 DEC 13."
Is ...
3
votes
1
answer
398
views
Creating animated line moving between points in QGIS
I have a point file, with Date:Time enabled. Rather than just animate the cycling through of points, I would like to have a line moving in a straight direction from one point to another in date order.
...
- 367
6
votes
1
answer
1k
views
Changing timezone of features attribute
When adding a feature I am adding a Datetime field to the layer (its of type memory layer). I set up the widget to also add the timezone:
But: when adding a feature it does not let me change the ...
- 35.6k
2
votes
1
answer
140
views
Translate Date Time CEST CET (OSM timestamp) in to CET YYYY-MM-dd (QGIS)
I need the date in YYYY-MM-DD (CET) from an OSM timestamp with mixed (CEST/CET) dates. The time is not necessary. Finally, I just want to show all records that are 7 days old (as expression to filter ...
- 8,396
1
vote
1
answer
41
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
718
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 ...
- 1,244
-2
votes
1
answer
106
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 ...
- 49
1
vote
1
answer
50
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 ...
- 111
1
vote
1
answer
852
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) {
...
- 11
3
votes
1
answer
509
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 ...
- 35.6k
8
votes
0
answers
157
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 ...
- 78k
3
votes
1
answer
2k
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:...
5
votes
1
answer
3k
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", "...
- 78k
7
votes
1
answer
3k
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", &...
- 78k
2
votes
0
answers
421
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 ...
- 21
0
votes
0
answers
148
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
2
votes
1
answer
307
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....
- 211
2
votes
0
answers
229
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 ...
- 91
2
votes
1
answer
265
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
621
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
129
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
662
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
...
- 8,356
0
votes
1
answer
284
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
115
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 ...
- 489
3
votes
3
answers
806
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
78
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
1k
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 ...
- 73
1
vote
1
answer
608
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, ...
4
votes
1
answer
11k
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
715
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
1k
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 ...
- 379
1
vote
1
answer
451
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