How to convert the date to the desired format?

Question

Microsoft SQL Server Integration Services

Dates are stored in the database in numerical form: 29366 - 05/25/1980. This is the format dt_date(int).

Answer 1

Found the solution
https://stackoverflow.com/questions/10759089/sql-s...

Answer 2

Documentation .

Answer 3

Well, for starters, it's worth excluding "like" - after looking at what specific format it is. For example, using SSMS or a query (eg exec sp_help 'table of interest'). Well, then either look in the direction of cast / convert or swear at the architect who angrily used the tricks from dabase-iv