I have 2 tables in Test DB.
The 1st table has a varchar(23) column which stores the date in string format. The 2nd table has a datetime coulmn, which stores the date in datetime format.
Considering performance, is it better to Convert the varchar cloumn to datetime format to compare dates between Table 1 and Table 2
is it better to Convert the datetime coumn in the 2nd table to string format and comapre the dates that way!