Home » SQL & PL/SQL » Client Tools » Timestamp Problem (Oracle 11g )
Timestamp Problem [message #624978] Mon, 29 September 2014 22:34 Go to next message
cool06prashant
Messages: 9
Registered: September 2014
Location: delhi
Junior Member
select TO_TIMESTAMP('2003/DEC/13 10:13:18', 'YYYY/MON/DD HH:MI:SS') from dual


Error:- ORA-03115: unsupported network datatype or representation

I try it on sql plus but same result.
Re: Timestamp Problem [message #624979 is a reply to message #624978] Mon, 29 September 2014 22:48 Go to previous messageGo to next message
BlackSwan
Messages: 25859
Registered: January 2009
Location: SoCal
Senior Member
It works OK for me.
[oracle@localhost ~]$ sqlplus user1/user1

SQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 29 20:47:25 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select TO_TIMESTAMP('2003/DEC/13 10:13:18', 'YYYY/MON/DD HH:MI:SS') from dual;

TO_TIMESTAMP('2003/DEC/1310:13:18','YYYY/MON/DDHH:MI:SS')
---------------------------------------------------------------------------
13-DEC-03 10.13.18.000000000 AM


Re: Timestamp Problem [message #624984 is a reply to message #624978] Mon, 29 September 2014 22:57 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
Probably your client version does not support it. Can you please tell what client are you using and what is the version. You said it is the same with SQL*Plus, can you show the session using copy paste like Blackswan did.
Re: Timestamp Problem [message #625022 is a reply to message #624979] Tue, 30 September 2014 06:52 Go to previous messageGo to next message
cool06prashant
Messages: 9
Registered: September 2014
Location: delhi
Junior Member
Snap Shot OF time stamp problem
/forum/fa/12195/0/

[mod-edit: image inserted into message body by bb]
  • Attachment: TEST.JPG
    (Size: 45.87KB, Downloaded 343 times)

[Updated on: Fri, 31 October 2014 10:55] by Moderator

Report message to a moderator

Re: Timestamp Problem [message #625025 is a reply to message #625022] Tue, 30 September 2014 07:12 Go to previous messageGo to next message
cookiemonster
Messages: 13017
Registered: September 2008
Location: Rainy Manchester
Senior Member
You can copy and paste text from sqlplus here you know, it's better than using an image.
Why are you using an 8i version of sqlplus against an 11g DB? That's a recipe for all sorts of problems.
Re: Timestamp Problem [message #625027 is a reply to message #625025] Tue, 30 September 2014 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Worse, not 8i but 8.0, can't definitively query a timestamp as it is a datatype that didn't exist in 8.0.

Re: Timestamp Problem [message #625029 is a reply to message #625022] Tue, 30 September 2014 08:09 Go to previous message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
So my guess was correct. Go to downloads and get latest version installed.
Previous Topic: Toad Error
Next Topic: How to Create user name and password after installation of oracle forms 6i
Goto Forum:
  


Current Time: Sun Feb 25 08:03:58 CST 2018

Total time taken to generate the page: 0.03320 seconds