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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

JustinCave
If you're familiar with nextval, I assume you are familiar with creating sequences and using sequences to populate primary keys...

You can always create a BEFORE INSERT trigger that automatically generates the primary key for the table. You would have to modify your INSERT statement to use the RETURNING clause if you want the client to have the value of the just-inserted primary key after the INSERT.

Justin
45878
You could create a trigger on the table which performs the "nextval" from a sequence table, that way your Java application does not need to do the work.
519688
use a sequence, and populate it via a "before insert for each row" trigger.

no other way.
514521
Not working..

From w/i SQLPLUS i execute this line:
create trigger dbame.p_trigger before insert on dbame.plant for each row

dbame is my oracle username
plant is the table name

SQLPLUS is looking for more information and/or a closing "tag" (not a semi-colon)

any help would be appreciated..

Thanks
Kamal Kishore
http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg13trg.htm#431
519688
read the manuals
look for the section on table triggers
1 - 6
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
81,274 views