Results 1 to 2 of 2
  1. #1
    Lawl is offline Member
    Join Date
    Mar 2011
    Posts
    4
    Rep Power
    0

    Post Date check constraint

    Hi there

    I'm a beginner using databases and currently working on my first database script where i'm trying to add different check constraints. I've looked around but can't seem to find any way to add a check to a date, which checks if the inserted row with a given date is older than the day it was created. Is this even possible or is there a easy why to add this?

    Using Oracle DB.

    Thanks in advance!
    Lawl

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    19

    Default

    I've not encountered a constraint setup like that.
    A pre-insert trigger might be the only solution, if you want to keep it in the db rather than checking beforehand in Java.

Similar Threads

  1. Check date using jstl
    By Samuel in forum JavaServer Pages (JSP) and JSTL
    Replies: 4
    Last Post: 11-15-2010, 01:06 PM
  2. Replies: 1
    Last Post: 09-27-2010, 12:44 PM
  3. check the sunday and saturday from a given date range
    By harsha.udupa2008 in forum New To Java
    Replies: 5
    Last Post: 07-20-2010, 08:22 AM
  4. how to remove constraint from output file
    By mazu in forum New To Java
    Replies: 18
    Last Post: 10-08-2009, 08:32 AM
  5. Creating a Gregorian Calendar using a Date object gives date - 1
    By prachi_goliwadekar in forum New To Java
    Replies: 1
    Last Post: 05-08-2008, 08:32 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •