ST_SetEndDateTime function to specify the end time of a raster - PolarDB

Sets the end time of a raster object.

Syntax

raster ST_SetEndDateTime(raster raster_obj, timestamp time);

Parameter	Description
`raster_obj`	The raster object whose end time you want to set.
`time`	The end time to assign to the raster object. Use the `yyyy-MM-dd HH:mm:ss` format. Example: `2020-08-30 18:00:00`.

The following example sets the end time of a raster object and returns the updated value using ST_endDateTime.

SELECT ST_endDateTime(ST_SetEndDateTime(raster_obj, '2020-01-01'))
FROM raster_table;

Output:

    st_enddatetime
-------------------------
 Wed Jan 01 00:00:00 2020