Current Date in auto-generated insert statement

bevpro

Where is the date coming from for an auto-generated insert statement for datetime columns? The time is off by 5 hours. I did a SELECT getdate() and the result is the correct time. But the VALUES portion of the generated insert statement for a datetime column has the incorrect time. Thanks!

David Priddle

Hi bevpro,

Which version of SQL Prompt are you running? Since Prompt 6.3, we use GETDATE() rather than a static date (feature request is located here).

Best regards,

David