0

I have string 20201001163318811 and I want to convert this into below format

2020-10-01 16:33:18.811

i.e

yyyy-mm-dd hh:mm:ss.ms

Improve this question
3
  • 2
    Does this answer your question? Converting bigint to datetime in sqlserver Commented Feb 17, 2021 at 17:16
  • Dates have no formats, they're binary values. Almost all databases have date types. Dates should never be stored as strings or numbers Commented Feb 17, 2021 at 17:17
  • @Larnu that's the one i was looking for.. thanks a lot Commented Feb 17, 2021 at 17:28
Related questions
4344
UPDATE from a SELECT
2450
Concatenate text from multiple rows into a single text string
3327
How to add a column with a default value to an existing table in SQL Server?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.