Popular Posts

  • Python Lists
    SQLServerCentral » Latest topics Python Lists Comments posted to this topic are about the item [B] Python Lists [/B] more info... ...
  • Python Lists
    SQLServerCentral » Latest topics Python Lists Comments posted to this topic are about the item [B] Python Lists [/B] more info... ...
  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Monday, November 13, 2017

format datetime to varchar

SQLServerCentral » Latest topics
format datetime to varchar

Hello,
I would like to convert a datetime column with values such as '2017-09-19 08:01:55.780' to  varchar like '2017-09-19T08:01:55.780'

So I try the following sql but I get an error
select FORMAT('2017-09-19 08:01:55.780','yyyy-MM-

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)