Convert Date and Time to UK (United Kingdom) Date format in SQL Server

Question

Please help how can i convert this date 20201116 121811243 and it remains its timestampI want to convert it to United Kingdom date format thanks in advance

dharmendr · Accepted Answer

Hi  makumbiUse FORMAT functionCheck the exampleSQLDECLARE startDate DATETIME  3920201116 12181124339SELECT FORMAT startDate 39ddMMyyyy hhmmss 39 39UK Date39OutputUK Date16112020 121811

Convert Date and Time to UK (United Kingdom) Date format in SQL Server

Company

Explore

Follow us

Contact Us