Date time with created date column RRS feed

  • Question

  • Hi,

    My SQl server management studio have the pacific time zone. so when i create a table, with created date, modified date column with getdate(). it returns date of current time pacific time.

    My requirement is created date, modified date need to show the the US Eastern day light saving time(EST) with datetime datatype.

    Please anyone suggest the Sql query for this.



    Monday, June 24, 2019 10:20 AM


All replies