Sets the end time of a raster object.
Syntax
raster ST_SetEndDateTime(raster raster_obj, timestamp time);Parameters
| Parameter | Description |
|---|---|
raster_obj | The raster object whose end time you want to set. |
time | The end time of the raster object. We recommend that you specify the time in the yyyy-MM-dd HH:mm:ss format. Example: 2020-08-30 18:00:00. |
Examples
The following example sets the end time of each raster object in raster_table to 2020-01-01 and retrieves the updated value using ST_endDateTime.
SELECT ST_endDateTime(ST_setEndDateTime(raster_obj, '2020-01-01'))
FROM raster_table;Expected output:
st_enddatetime
-------------------------
Wed Jan 01 00:00:00 2020