Home » SQL & PL/SQL » SQL & PL/SQL » display date with time
display date with time [message #196735] Fri, 06 October 2006 22:50 Go to next message
ashish_pass1
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
sir,
i want to display my dely_date column with time(hh:mm:ss)
for it what will i do?
table is like this--

ORDER_ CLIENT dely_date
------ ------ ----------
O19001 C00001 20/01/1996
O19002 C00002 27/01/1996
O46865 C00003 20/02/1996
O19003 C00001 07/04/1996
O46866 C00004 22/05/1996
O19008 C00005 26/05/1996

6 rows selected

thanxxx
Re: display date with time [message #196736 is a reply to message #196735] Fri, 06 October 2006 23:10 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi

use in your query

to_char(delay_date,'dd/mm/rrrr hh:mi:ss pm')as delay_date

or

to_char(delay_date,'dd/mm/rrrr hh24:mi:ss') as delay_date


i hope that it will work for you

regards
Muhammad Shahid Mughal


Re: display date with time [message #196768 is a reply to message #196736] Sat, 07 October 2006 03:20 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

alter session set nls_date_format = 'dd-mon-yyyy hh24:mi:ss';
Previous Topic: Help tune this SQL
Next Topic: index is in unusable state - Please help
Goto Forum:
  


Current Time: Sun Dec 04 02:20:11 CST 2016

Total time taken to generate the page: 0.08529 seconds