SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert exact code from sql server function to oracle function?

955649Sep 8 2012 — edited Sep 10 2012

Hi sir i am converting one function through sql developer but i am not able to convert properly some error i am getting.

in this line i am getting error:

here is my sql script line: convert(datetime,fdate,103)

in this i am converting fdate column to datetime

and after converting this in oracle it is coming like this

sqlserver_utilities.convert_('DATE', fdate, 103)

but in this line i am getting error

could you please convert it properly.

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 8 2012

Added on Sep 8 2012

#11g, #sql-developer

4 comments

1,680 views