0

My insert scripts in oracle are below format.

INSERT INTO SAMPLETABLE(CREATEDDATE) VALUES (to_timestamp ('21-MAY-20 03.36.36.000000000 PM','DD-MON-RR HH.MI.SSXFF AM'));

I want it to convert the same in SQL Server format.

Thanks for any help in advance :)

Improve this question
2
  • 1
    what have you tried? Have you trisome converting / casting whatever you want into timestamp? Commented Jun 26, 2020 at 1:51
  • Hi Harry, yes i tried to check with Convert by keeping datetime and datetime2 but it doesnt give complete timestamp.. Commented Jun 26, 2020 at 2:06
Related questions
4343
How do I UPDATE from a SELECT in SQL Server?
3327
How to add a column with a default value to an existing table in SQL Server?
2450
Concatenate text from multiple rows into a single text string
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.