If the built in functions don't work, have you tried the Left, Mid and Right functions. Use these functions to extract the year, month, day and time and then convert each to its date/time component. Then concanenate them together. I hope this works.
I created reports using Sybase SQL and then we switched the database to Oracle. Oracle did not understand the SQL query being generated since the SQL was written for Sybase. I asked an Oracle DBA to help me edit the SQL in database¦show SQL Query and it worked.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.