Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Database & SysAdmin
  3. Database
  4. insert 'SYSDATE' into a table in SQL Server

insert 'SYSDATE' into a table in SQL Server

Scheduled Pinned Locked Moved Database
databasehelpsql-serversysadminquestion
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    alexyxj
    wrote on last edited by
    #1

    again, I tried to run the following query INSERT INTO table1 (SID, Time) VALUES (1, SYSDATE) but got the error message as below: Msg 128, Level 15, State 1, Line 1 The name "SYSDATE" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Can anyone tell me what the problem is? Thanks....

    W 1 Reply Last reply
    0
    • A alexyxj

      again, I tried to run the following query INSERT INTO table1 (SID, Time) VALUES (1, SYSDATE) but got the error message as below: Msg 128, Level 15, State 1, Line 1 The name "SYSDATE" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Can anyone tell me what the problem is? Thanks....

      W Offline
      W Offline
      Wendelius
      wrote on last edited by
      #2

      SYSDATE is an Oracle function. Use GETDATE().

      The need to optimize rises from a bad design. My articles[^]

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups