If an unique key constraint on DATE column is created, will it validate the ro

If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?

Question Posted / guest

4 Answers
13074 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / kangana

uNIQUE CONSTARINT CAN VALIDATE PSEUDOCLOUMN SYSDATE

SYSDATE FORMAT IS LIKE 3/2/2010 8:42:46 PM

SO FOR EACH MILLISECOND IF U INSER A ROW IT WILL TAKE THE
INSERTION BUT IF U INSERT IN EACH FRACTION OF MILLISECOND
ITS VALIDATE AND UNIQUE CONSTARINT IS VOILATED.

Is This Answer Correct ?

14 Yes

0 No

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / nagendra

Yes, it will validate the rows that are inserted with sysdate

Is This Answer Correct ?

9 Yes

3 No

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / zikku

No Date column can not validate the rows that are inserted
with sysdate.

Is This Answer Correct ?

5 Yes

3 No

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / chandrasekar ramasamy

No B'coz the sysdate contains date and time format

Is This Answer Correct ?

5 Yes

3 No

Post New Answer