Home » SQL & PL/SQL » SQL & PL/SQL » Query do not show the time 00:00:00
icon8.gif  Query do not show the time 00:00:00 [message #219068] Mon, 12 February 2007 16:22 Go to next message
LeoWins
Messages: 3
Registered: February 2007
Location: Colombia
Junior Member
Hello, sorry if the question is already posted (I search but not found anything).

I have a system that have a 24 hour operation, when I make a query with the date time field this is the result :

select fecha from regs order by date_time

2006/11/01 14:00:01
2006/11/01 15:00:01
2006/11/02
2006/11/02 14:58:01


the 3th register do not show the hour, but is 00:00:00.

Oracle by default assumes the hour 00:00:00 like only the day ??
or is simply a issue of formating the query ?

thanks in advance

Re: Query do not show the time 00:00:00 [message #219070 is a reply to message #219068] Mon, 12 February 2007 16:34 Go to previous messageGo to next message
pselvam76
Messages: 12
Registered: February 2007
Junior Member
Hi

If you format it you can see the 00:00:00. Use the following sql.

select to_char(fecha,'yyyy/mm/dd hh24:mi:ss') from regs order by date_time;

Thanks
Panneer Selvam
Re: Query do not show the time 00:00:00 [message #219071 is a reply to message #219070] Mon, 12 February 2007 16:44 Go to previous messageGo to next message
LeoWins
Messages: 3
Registered: February 2007
Location: Colombia
Junior Member
Thank for your reply.

I'll also try change the NLS_TIME_FORMAT

Re: Query do not show the time 00:00:00 [message #219115 is a reply to message #219071] Tue, 13 February 2007 00:32 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
what datatype is your fecha column?
Re: Query do not show the time 00:00:00 [message #219233 is a reply to message #219115] Tue, 13 February 2007 11:22 Go to previous message
LeoWins
Messages: 3
Registered: February 2007
Location: Colombia
Junior Member
the format is DATE

THX
Previous Topic: Unhandled user Exception- except handled
Next Topic: how to delim records in sqlplus
Goto Forum:
  


Current Time: Tue Dec 06 06:14:31 CST 2016

Total time taken to generate the page: 0.10088 seconds