SQL & PL/SQL

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!

sql developer - To_Char not a recognised function

majortomJun 21 2010 — edited Jun 21 2010

Hi All

I have a SQL Server 2005 database connected through Oracle SQL Developer V 1.5.1 . I am attempting to convert the system date to a character date in the form of YYYYMMDD.

So I used this statement but it comes back with the error that it is not a valid function.

TO_CHAR(sysdate,'YYYYMMDD')

I have searched the net but cant seem to fix this, does it mean that TO_CHAR only works if you are connected to an Oracle Database?
If so is there another function I can use for this?

cheers

This post has been answered by Tubby on Jun 21 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 19 2010

Added on Jun 21 2010

3 comments

2,850 views