Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2012
    Posts
    2

    Wink How To Set Default DATE..

    Hello, I am new here and wanted help with how to assign DATE a default value using SYSDATE function.

    I have tried but its not working accordingly:

    Code:
    ALTER TABLE Deposit ADD FirstCreated DATE (SYSDATE);
    Thanks
    Vrutin

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,650
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  3. #3
    Join Date
    Sep 2012
    Posts
    18
    Alter table ad add v_date date (default sysdate)

  4. #4
    Join Date
    Nov 2012
    Posts
    2
    Hi,

    You can use following code:

    CREATE TABLE MY_TABLE
    (
    MY_DATE_FIELD DATE default sysdate NOT NULL
    );

    Thanks!
    Last edited by Pat Phelan; 11-30-12 at 07:49. Reason: Removed commercial URL

Posting Permissions

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