Assumption: You mean a datetime/datetime2 type and not the timestamp data type (which is just a synonym for rowversion) -- a guid-like value used for versioning.

If you are in an...

I don't know that you could/should in TSQL.

Here is an example that uses SQL CLR to convert PDF into a series of images: https://www.codeproject.com/Articles/34551/Reporting-Services-2008-Embedding-a-PDF-Document

I don't know why this conversion couldn't be...

Yes. AWS added that capability for SQL Server in November 2017: https://aws.amazon.com/about-aws/whats-new/2017/11/amazon-rds-for-sql-server-supports-scaling-storage-size/

A couple caveats in https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ModifyInstance.SQLServer.html:

Can't change storage for 6 hours after a change.

Some older DB instances don't support storage...