Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to concatenate time to a date

user633278Jan 8 2010 — edited Jul 24 2013
Hi

I have a third party reporting, where I need to pass dates to my oracle database in order to execute a query. The query itself will be executed by the reporting tool. However, in the database the date has the time included in it, and what I would like to do is to add to the sql query a default time element when the date is passed. Therefore, when the date 06-Jan-2010 has been entered in by the user, then the time 23:59:00 is added to the query as well.

How do I concatenate the time element in a sql query when a date is being passed?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2013
Added on Jan 8 2010
5 comments
82,276 views