Looking for feedback on how I did this. I have two sets of data with Dates all stored in a column as varchar.
Table 1 has Dates stored as YYYY-MM-DD as varchar and I used the query below to convert them to MM/DD/YYYY as required by the recipient:
Convert(varchar, (select convert(datetime,[Date_OF_VISIT])), 103) as [Date_of_Visit]
Table 2 has Dates stored in date time format YYYY-MM-DD 00:00:00.000 and I used this:
Convert(varchar, [DATE_OF_BIRTH ], 103) as [Date_OF_BIRTH]
The data in the tables is to be exported as a text delimited file and then shipped off. Did I use the best method?
-Mark
MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.