Toad World® Forums

Display of time with date in the table


#1

CREATE OR REPLACE TRIGGER TR_BASICS_CREATED

ON TBL_BASICS REFERENCING NEW AS New OLD AS OldFOR

BEGIN

IF :NEW.created_on IS NULL THEN

SELECT SYSDATE

INTO :NEW.created_on FROM DUAL;

end if;

I use Toad to query records from the oracle table. When a new record is inserted the database uses the following trigger to insert the created on date. On retrieving the records from the table, I see the time portion is displayed only for certain records eventhough the same trigger is used for all the inserts. Does it depend on any TOAD settings? If so, what is it?

BEFORE INSERTEACH ROWEND TR_BASICS_CREATED;

Thanks.

Note: I am new in this forum and I was not sure where to post my question. Hence, I have posted the same question in the ‘oracle discussion’ category too. Sorry about the redundancy.