Use ST_SetBeginDateTime to set the start time of a raster - ApsaraDB RDS

Sets the start time of a raster object.

Syntax

raster ST_SetBeginDateTime(raster raster_obj, timestamp time);

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

The following example sets the start time of raster_obj to 2020-01-01 and then retrieves the 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