INSERT Statement date format

• 
  hey ABarthen,
  what is the SQL Prompt version you're speaking of? When I write the INSERT statement the default value for datetimes is GETDATE() right now (SQL Prompt 9.1.1.4243).

  AlessandroAlpi March 09, 2018 08:42

  - 0 +
• 
  9.0.4.3408
  I was not aware there was a newer Version, I reinstalled this only a few months ago (before that date fields were not autofilled at all)
  I will check out the new version (assuming we have the license for that, don't really know about that).
  Thank you for your quick reply.

  ABarthen March 09, 2018 08:46

  - 0 +
• 
  My version is actually a frequent update version. If you upgrade I don't know if you'll find out it.

  AlessandroAlpi March 09, 2018 08:48

  - 0 +
• 
  Strange, I'm on 9.1.2.4363 now and don't have GETDATE().
  
  Also, if you are on the freequent update branch, the currently latest version shouldn't be on 9.1.2 when you're on 9.1.1.

  ABarthen March 09, 2018 08:56

  - 0 +
• 
  I'd like to wait to update actually, because of my team needs. That said, I cannot get the dates. I'm still getting the GETDATE() layout.
  

  CREATE TABLE foo (dd datetime);
  GO
  
  INSERT INTO dbo.foo (dd)
  VALUES
       (GETDATE() -- dd
      )
  

  
  What is the version of your SQL Server?

  AlessandroAlpi March 09, 2018 09:02

  - 0 +
• 
  Server Version is 12.0.2269.0 and 13.0.1601.5, the problem is the same on both.
  I am using SQL Server Management Studio 17.4 (14.0.17213.0)

  ABarthen March 09, 2018 09:29

  - 0 +
• 
  The same for me. Tried and got GETDATE() on the default render.

  AlessandroAlpi March 09, 2018 11:27

  - 0 +

Add comment

Please sign in to leave a comment.