OraFAQ Forum: SQL & PL/SQL » Problem in hh:min:sec?

Home » SQL & PL/SQL » SQL & PL/SQL » Problem in hh:min:sec?

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

Problem in hh:min:sec? [message #275659]

Mon, 22 October 2007 04:25

tondapi
Messages: 99
Registered: August 2007
Location: usa

Member

Hi

I am new to sql i want to display only hh:min:sec with any date

How can i genrate it?

Report message to a moderator

Re: Problem in hh:min:sec? [message #275661 is a reply to message #275659]

Mon, 22 October 2007 04:30

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

Senior Member
Account Moderator

Using the appropriate format mask:

SQL> select to_char(sysdate, 'hh24:mi:ss') from dual;

TO_CHAR(
--------
11:30:27

SQL>

Report message to a moderator

Re: Problem in hh:min:sec? [message #275663 is a reply to message #275659]

Mon, 22 October 2007 04:35

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Assuming you want to study and not just an answer, have a look at:
Database SQL Reference
Chapter 2 Database SQL Reference
Section Format Models
Subsection Datetime Format Models

Regards
Michel

Report message to a moderator

Re: Problem in hh:min:sec? [message #275667 is a reply to message #275661]

Mon, 22 October 2007 04:40

tondapi
Messages: 99
Registered: August 2007
Location: usa

Member

it displaying date also i want to see only hh:min:ss

Report message to a moderator

Re: Problem in hh:min:sec? [message #275669 is a reply to message #275667]

Mon, 22 October 2007 04:41

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read the link and LittleFoot's answer. Do you see a date in his result?

Regards
Michel

Report message to a moderator

Re: Problem in hh:min:sec? [message #275700 is a reply to message #275667]

Mon, 22 October 2007 07:56

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

tondapi wrote on Mon, 22 October 2007 05:40

it displaying date also i want to see only hh:min:ss

Really now? I'd like to see that. Sorry, but I do not believe you. Cut and paste your complete session.

Report message to a moderator

Previous Topic:	invalid connect
Next Topic:	escape function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 02:29:57 CST 2025