Home » SQL & PL/SQL » SQL & PL/SQL » seconds in day must be between 0 and 86399
icon3.gif   seconds in day must be between 0 and 86399 [message #288554] Tue, 18 December 2007 00:30 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear Friend..
please Give me advice/Soln about the query.
----------------------------------------------------------
select TO_DATE(A.ATND_DATE||','||(TO_char(B.START_TIME,'SSSSS') + TO_char(B.RELAX_TIME,'SSSSS')),'DD-MON-YY,SSSSS')
from
HM_ATND_RAW A,HM_SHIFT_MST B

ERROR:
ORA-01853: seconds in day must be between 0 and 86399
no rows selected

SQL>
---------------------------------------------------------
regards
Zia
Re: seconds in day must be between 0 and 86399 [message #288556 is a reply to message #288554] Tue, 18 December 2007 00:33 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Looks like a very self-explaining message to me.

Which two numbers are you adding? Adding up to what?
Re: seconds in day must be between 0 and 86399 [message #288560 is a reply to message #288554] Tue, 18 December 2007 00:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you want to make arithmetic on date, it is better to make arithmetic on date than trying to switch back and forth string.

date+(second1+second2)/86400

Regards
Michel
Re: seconds in day must be between 0 and 86399 [message #288784 is a reply to message #288554] Tue, 18 December 2007 11:46 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
And to make Michel's excellent response clearer to you,

date + ((second1+second2)/86400)
Previous Topic: Spool time in query
Next Topic: select over filter
Goto Forum:
  


Current Time: Mon Feb 10 09:34:28 CST 2025