Use ST_SetBeginDateTime to specify the start time of a raster - PolarDB

Sets the start time of a raster object.

Syntax

raster ST_SetBeginDateTime(raster raster_obj, timestamp time);

Parameter	Description
`raster_obj`	The raster object whose start time you want to set.
`time`	The start 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 start time of each raster in raster_table to 2020-01-01 and retrieves the updated value using ST_beginDateTime.

SELECT ST_beginDateTime(ST_setBeginDateTime(raster_obj, '2020-01-01'))
FROM raster_table;

Output:

     st_begindatetime
-------------------------
 Wed Jan 01 00:00:00 2020