sql-generate-insert icon indicating copy to clipboard operation
sql-generate-insert copied to clipboard

datetime columns conversion

Open maximnl opened this issue 4 years ago • 0 comments

problem: extra size/performance issues due to convert for datetime

solution explicit conversion for date or datetime is unnecessary, instead of convert(datetime,'2020-01-01 00:00',121) , there should be just '2020-01-01 00:00'. sql server does perfect job in converting datetime if value strings are in sql server date format

maximnl avatar Oct 28 '21 15:10 maximnl