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
Messages: 114
Registered: August 2006
Location: delhi
Senior Member
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

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
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan


use in your query

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


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

i hope that it will work for you

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: Sat Jul 22 18:11:04 CDT 2017

Total time taken to generate the page: 0.05603 seconds