Results 1 to 2 of 2

Thread: Date Query

  1. #1
    Join Date
    Jan 2004
    Posts
    67

    Unanswered: Date Query

    I have a requirement like this.

    I want to Insert records into the table.

    If i have the date as today's date, then i want to delete all the existing records, and make a new Insert with the Current Timestamp.

    Can someone give me a query for this

    Thanks
    Shankar

  2. #2
    Join Date
    Jun 2002
    Posts
    1
    1. do the insert using a stored procedure.
    or
    2. Have trigger in background, that fires before every insert to check the sysdate....

Posting Permissions

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