ParseExact
This function convert a string to a date with a custom format.
Example: select config.ParseExact('2022-01 08','yyyy-MM HH') 2022-01-01 08:00:00.0000000
select config.ParseExact('2022-01 08','yyyy-MM HH')
Parameters:
@date the string with the date
@format the format how date is wrote