Convert query from Oracle to SQL server

Question

I want to convert below Oracle query into SQL server environment-

select to_date(substr(to_char(col1, 'YYYYMMDD HH24MISS),1,8), 'YYYYMMDD') from tab;

From the above query i want to convert it into first time in Date format and then second time Time format. It means two times i want this query while above one in Date format.

Gordon Linoff · Accepted Answer · 2017-12-08 10:24:10Z

2

This is not even how I would do this in Oracle. This is converting the date/time value to a date, with no time component. In SQL Server:

select cast(col1 as date)
from tab;

In Oracle:

select trunc(col1)
from tab;

answered Dec 8, 2017 at 10:24

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert query from Oracle to SQL server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related