Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    42

    Unanswered: how do we insert system date

    Hi,

    iam getting confused with this error.

    Iam trying to insert the sysdate in a table

    for eg,

    insert into emp(empjoindate) values (sysdate());

    like this i want to insert the sysdate, is there any proper way to give sysdate.

    please do reply with code.

    Thanking you.

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    62

    Smile

    insert into emp(empjoindate) values (sysdate);
    This will insert sysdate with date + time info.
    Regards,

    Rushi

  3. #3
    Join Date
    Jan 2004
    Posts
    84
    INSERT into table values(to_char(SYSDATE,'dd-mon-yyyy hh:mi:ss')) should do.
    The data type for thE inserted value can be VARCHAR.

Posting Permissions

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