#DateForumTypeThreadPost
301 Jul 2015 @ 07:34 PDTAnalyticsReplyCast Seconds (Data type HS) too Hour:Minutes:Seconds Time data typeselect cast(substr('0 20:50:00.000000',index('0 20:50:00.000000',' ')) as time);
201 Jul 2015 @ 07:28 PDTAnalyticsReplyIS-NUMERIC functionsI think it should be just: select to_number( charval ) otherwise you're missing values like "0", "0.00" etc.    
113 Aug 2014 @ 04:17 PDTConnectivityTopicSQL Assistant and ORA-12154 on 64-bit Windows platforms (but not on 32-bit)Since it appears SQL Assistant is still available only in 32-bit version (TD 14/15 clients), it attempts to connect to Oracle's 32-bit ODBC. On 32-bit Windows platforms everything is peachy. ...