ST_SetEndDateTime-AnalyticDB(AnalyticDB)-阿里云帮助中心

Sets the end datetime of a raster object.

Syntax

raster ST_SetEndDateTime(raster raster_obj, timestamp time);

Parameter	Description
`raster_obj`	The raster object whose end datetime you want to set.
`time`	The end datetime of 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 datetime of a raster object to 2020-01-01 and then retrieves the 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