What is N in nvarchar in SQL Server

Convert string to date type in Athena AWS SQL

Zimmerman

I have a column that called date with the following format : '20220816' how can I convert this column into Date format?

I tried to use this function : date_parse(date,'%y/%m/%d') but it keep giving me this error: NVALID_FUNCTION_ARGUMENT: Invalid format: "20220627" is malformed at "220627"