What are the challenges you face when working across database platforms? Take the survey
Options

INSERT Statement date format

ABarthenABarthen Posts: 4 New member
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)?

Best Answer

Answers

Sign In or Register to comment.