OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » CURRENT TIME

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

CURRENT TIME [message #604606]

Wed, 01 January 2014 23:48

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

sir,
i want current time in oracle 9i form ,i am using this

select to_char(sysdate, ' DD-Mon-YYYY HH12:MI:SS') as "Current Time"
from dual;

but it is not working in oracle form 9i.giving error.

give me some solution for this.

regards.

Report message to a moderator

Re: CURRENT TIME [message #604608 is a reply to message #604606]

Thu, 02 January 2014 00:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member


SQL>  
select to_char(sysdate, ' DD-Mon-YYYY HH12:MI:SS') as "Current Time"
from dual;SQL>   2  

Current Time
------------------------------
 01-Jan-2014 09:54:05

Report message to a moderator

Re: CURRENT TIME [message #604610 is a reply to message #604608]

Thu, 02 January 2014 00:10

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

it is not working in oracle 9i forms.

Report message to a moderator

Re: CURRENT TIME [message #604611 is a reply to message #604610]

Thu, 02 January 2014 00:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

my car is not working.
Tell me how to make my car go.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>but it is not working in oracle form 9i.giving error.
ERROR? What Error?
I don't see any error.

[Updated on: Thu, 02 January 2014 00:15]

Report message to a moderator

Re: CURRENT TIME [message #604678 is a reply to message #604606]

Thu, 02 January 2014 11:13

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forms uses PL/SQL, so your SELECT statement (maybe) misses the INTO part, i.e.

declare
  l_right_now varchar2(30);
begin
  select to_char(sysdate, ' DD-Mon-YYYY HH12:MI:SS') 
  into l_right_now
  from dual;
end;

Report message to a moderator

Previous Topic:	ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit
Next Topic:	Please help me to resolve this

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:04:05 CDT 2024