SQL date conversion to mm/dd/yyyy hh:mm-CodePudding

Home > OS > SQL date conversion to mm/dd/yyyy hh:mm

SQL date conversion to mm/dd/yyyy hh:mm

Time：02-11

Can't seem to find answer to what seems like a simple question. I have a date that is returned 2022-02-07 18:53:36.000 I need to convert that date to mm/dd/yyyy hh:mm. Is that possible?

CodePudding user response：

select convert(varchar, getdate(), 13);

CodePudding user response：

I got the answer from another site. I've tested it and it works.

(CONVERT(VARCHAR(20), ea.event_timestamp, 101)   ' '   LEFT(CONVERT(VARCHAR(20),ea.event_timestamp, 108) ,5)) AS  EventDate

Page link：https//www.codepudding.com/os/295578.html

Prev:Is there a way of conditionally selecting which WHERE-clause to use in an SQL query?

Next:Running a stored procedure using a resultset as the parameter and insert into a table

Tags：

tsql

Links：
CodePudding