Converting DateTime to String in SQL Server & Postgres

Question

I've datetime value 2020-06-29 18:12:23 and I am trying to convert this to 20200629181223format in both SQL Server & Postgres

Any thoughts please? Thanks!

Answer 1

You can also use to_char method like following on postgres

to_char(created_date, 'dd/mm/yyyy')

created_date is of type timezone with timezone here

You can read more use cases here

Answer 2

This is easy with a convert and nested replace functions:

select replace(replace(replace(convert(varchar,getdate(),120),' ',''),'-',''),':','')