current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I generated the DDL from Oracle to Sybase, created the tables with no issues even migrated most tables into Sybase using insert into, however when came to the time functions I get errors:

Function 'to_date' not found. If this is a SQLJ function or SQL function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).

and

Function 'to_timestamp' not found. If this is a SQLJ function or SQL function, use sp_help to check whether the object exists (sp_help may produce a large amount of output).

share|improve this question
    
These are probably Oracle DB functions that are not available in Sybase. You will need to figure out what the functions are doing, and then translate that into TSQL. For both of those you will likely have to use the convert() function, but unless I see the code, I can't give a complete answer. –  Michael Gardner May 28 '13 at 14:31
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.