How can we help you today? How can we help you today?

Current Date in auto-generated insert statement

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!
bevpro
0

Comments

1 comment

Sort by
  • 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
    David Priddle
    0

Add comment

Please sign in to leave a comment.