OraFAQ Forum: Client Tools » Timestamp Problem

Home » SQL & PL/SQL » Client Tools » Timestamp Problem (Oracle 11g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Timestamp Problem [message #624978]

Mon, 29 September 2014 22:34

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.

Report message to a moderator

Re: Timestamp Problem [message #624979 is a reply to message #624978]

Mon, 29 September 2014 22:48

BlackSwan
Messages: 26757
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

Report message to a moderator

Re: Timestamp Problem [message #624984 is a reply to message #624978]

Mon, 29 September 2014 22:57

Lalit Kumar B
Messages: 3171
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.

Report message to a moderator

Re: Timestamp Problem [message #625022 is a reply to message #624979]

Tue, 30 September 2014 06:52

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 1135 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

cookiemonster
Messages: 13895
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.

Report message to a moderator

Re: Timestamp Problem [message #625027 is a reply to message #625025]

Tue, 30 September 2014 07:17

Michel Cadot
Messages: 67648
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.

Report message to a moderator

Re: Timestamp Problem [message #625029 is a reply to message #625022]

Tue, 30 September 2014 08:09

Lalit Kumar B
Messages: 3171
Registered: May 2013
Location: World Wide on the Web

Senior Member

So my guess was correct. Go to downloads and get latest version installed.

Report message to a moderator

Previous Topic:	Toad Error
Next Topic:	How to Create user name and password after installation of oracle forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 22 20:42:38 CST 2021