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

INSERT Statement date format

ABarthenABarthen Posts: 4 New member

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


Sign In or Register to comment.