Skip to main content

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
0 votes
1 answer
39 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 ...
Mícheál's user avatar
  • 147
4 votes
1 answer
84 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/...
Dave X's user avatar
  • 1,699
0 votes
0 answers
15 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 ...
Paula Torres's user avatar
0 votes
1 answer
47 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 ...
Immo Woschny's user avatar
3 votes
1 answer
199 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 ...
Abdy's user avatar
  • 33
1 vote
1 answer
151 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 ...
Selma's user avatar
  • 301
4 votes
1 answer
221 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 ...
BramV's user avatar
  • 107
0 votes
1 answer
143 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 ...
Peter Koltai's user avatar
2 votes
0 answers
39 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&...
Garrytre's user avatar
1 vote
1 answer
112 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: ...
Mestrexama's user avatar
3 votes
1 answer
54 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 ...
Barbara Perez de Araújo's user avatar
5 votes
1 answer
310 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 ...
Stu Smith's user avatar
  • 8,160
0 votes
1 answer
284 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 ...
Arthur_Morgan's user avatar
2 votes
1 answer
261 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 ...
rpenman's user avatar
  • 33
2 votes
0 answers
141 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 ...
sermomon's user avatar
  • 994
2 votes
2 answers
122 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 ...
b_squared's user avatar
0 votes
2 answers
385 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 ...
Richard Livingston's user avatar
3 votes
1 answer
362 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. ...
Matt Houston's user avatar
6 votes
1 answer
803 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 ...
MrXsquared's user avatar
  • 34.9k
2 votes
1 answer
118 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 ...
MartinMap's user avatar
  • 8,328
1 vote
1 answer
37 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 ...
Ewen's user avatar
  • 121
2 votes
1 answer
616 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 ...
Arthur_Morgan's user avatar
-2 votes
1 answer
97 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 ...
cerroGIS's user avatar
1 vote
1 answer
48 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 ...
Ram's user avatar
  • 111
1 vote
1 answer
770 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) { ...
João Naime's user avatar
3 votes
1 answer
450 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 ...
MrXsquared's user avatar
  • 34.9k
8 votes
0 answers
149 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 ...
Kadir Şahbaz's user avatar
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:...
Gabriela Chaves's user avatar
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", "...
Kadir Şahbaz's user avatar
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", &...
Kadir Şahbaz's user avatar
2 votes
0 answers
385 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 ...
BrGIS's user avatar
  • 21
0 votes
0 answers
142 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... ...
Flo's user avatar
  • 71
2 votes
1 answer
279 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....
Tuyen's user avatar
  • 211
2 votes
0 answers
220 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 ...
Swordnut's user avatar
2 votes
1 answer
230 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() - "...
Jürg's user avatar
  • 23
0 votes
1 answer
564 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 ...
libbyzu welch's user avatar
0 votes
0 answers
115 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 ...
Linda's user avatar
  • 39
7 votes
3 answers
618 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 ...
Stu Smith's user avatar
  • 8,160
0 votes
1 answer
264 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. ...
Oliver's user avatar
  • 37
0 votes
1 answer
107 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 ...
Andrew's user avatar
  • 489
3 votes
3 answers
702 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
kartographinya's user avatar
3 votes
1 answer
75 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(&...
Human_BetaRelease's user avatar
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 ...
Riz's user avatar
  • 67
1 vote
1 answer
500 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, ...
Mr. Geologist's user avatar
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....
Mr. Geologist's user avatar
4 votes
3 answers
638 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 ...
syed's user avatar
  • 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 ...
Bacon_Sammich's user avatar
1 vote
1 answer
437 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 ...
Omega's user avatar
  • 335
0 votes
1 answer
563 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.
Comrade Che's user avatar
  • 7,251
1 vote
1 answer
240 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
bwgis's user avatar
  • 21