Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 28, 2012 01:34 AM by april_123456
Member
376 Points
1046 Posts
Dec 17, 2012 09:34 AM|LINK
my table has two fields fromtime and totime with time format 'HH24:MI' such as (24:00 or 01:00)
how can i check if the input paramter overlap the above 2 field.
two input parameter: start & to with varhcar 09:00 how to convert to date format?
Participant
775 Points
248 Posts
Dec 28, 2012 01:34 AM|LINK
Hello -_-
With Regards to your question, please visit the following. You may find it useful and beneficial.
http://www.orafaq.com/node/2067
Hope this is helpful.
Best of Luck!
With Kind Regards,
-_-
Member
376 Points
1046 Posts
time overlap (oracle)
Dec 17, 2012 09:34 AM|LINK
my table has two fields fromtime and totime with time format 'HH24:MI' such as (24:00 or 01:00)
how can i check if the input paramter overlap the above 2 field.
two input parameter: start & to with varhcar 09:00 how to convert to date format?
april_123456
Participant
775 Points
248 Posts
Re: time overlap (oracle)
Dec 28, 2012 01:34 AM|LINK
Hello -_-
With Regards to your question, please visit the following. You may find it useful and beneficial.
http://www.orafaq.com/node/2067
Hope this is helpful.
Best of Luck!
With Kind Regards,