INSERT Statement date format

ABarthen

Hi,

Is there any way to change the format of the date default value inserted by SQL prompt when auto completing an INSERT statement?
Currently date fileds get filled with the current date in the format yyyy-MM-dd HH:mm:ss.
This does not work on our (german) versions of SQL Server/Studio, "-" between the days/Months is not valid.

We require date in ISO yyyyMMdd HH:mm:ss format. Simply GETDATE() also works, which is what I usually replace these values with.

Is there currently a ways to change this format (or use GETDATE instead of the current date as a string)?

AlessandroAlpi

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).

ABarthen

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.

AlessandroAlpi

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

ABarthen

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.

AlessandroAlpi

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?

ABarthen

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)

AlessandroAlpi

The same for me. Tried and got GETDATE() on the default render.