Share via

convert multiple date format in the column

Shambhu Rai 1,411 Reputation points
2022-08-10T04:53:20.42+00:00

Hi Expert,,
i have multiple timestamp format value in a column how to convert it to_timestamp condition

column1
23/12/2022
12/22/2021
23-12-2022

Best Regards,

SQL Server Integration Services
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
SQL Server | Other

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,781 Reputation points
    2022-08-10T16:18:06.173+00:00

    Without a consistent format, there is no way for ANY system to guess if "3/1/2022" means March 1 2022, or Jan 3 2022.

    Your date must be in a known format for conversion.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.