how to insert Date

Results 1 to 2 of 2

Thread: how to insert Date

  1. #1
    Join Date
    Dec 1969

    Default how to insert Date

    I would like to know how to insert the current date into Microsoft Access using SQL statement? <BR>

  2. #2
    New ASP Guest

    Default RE: how to insert Date

    SQL = "INSERT INTO yourtable (DATE_TIME) VALUES ("#" & NOW & "#")<BR><BR>This ONLY works in Access!!!<BR><BR>NOT oracle.<BR>

Posting Permissions

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