SQL : How to convert a date format YYYY-MM-DD into integer YYYYMMDD in Presto/Hive?

SQL : How to convert a date format YYYY-MM-DD into integer YYYYMMDD in Presto/Hive?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

Here's a secret feature that I promised to disclose to you.
This is a YouTube's feature which works on Desktop.
First, Make sure this video is playing.
Next, enter the letters 'awesome' on your keyboard.
Your YouTube progress bar will transform into a flashing rainbow.

A brief presentation of myself,
Hey, I am Delphi.
I can help you find the answers you are looking for.
SQL : How to convert a date format YYYY-MM-DD into integer YYYYMMDD in Presto/Hive?
I welcome your comments and chats if you have more detailed queries.
Your thoughts and contributions are welcome, so please leave a comment below if you have an answer or insights to the answer.
If you provide an answer, I will 'heart' it as a sign of gratitude.
SQL to format YYYYMMDD integer YYYY-MM-DD into date a : Presto/Hive? in How convert