Need to convert date_part from postgres to oracle

Question

I have a query in the postgres : select date_part('week', CURRENT_DATE) The outcome of this query is 36.

I need to convert the same postgres query into Oracle . How do I do this ? I tried the below query but I am getting an outcome as 5. select to_number(to_char(CURRENT_DATE,'Week'))FROM DUAL

Rene · Accepted Answer · 2015-08-31 07:11:38Z

1

Have a look at the Oracle date formats:

http://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements004.htm#i34924

select to_char(current_date,'IW') from dual

answered Aug 31, 2015 at 7:11

Rene

10.6k5 gold badges37 silver badges48 bronze badges

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

1 Comment

user1538020 Over a year ago

Thanks mate! Will check this out !

Collectives™ on Stack Overflow

Need to convert date_part from postgres to oracle

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related