Can I configure the DateTime to default to Local Time?

mikemod

I want DateTime to default to Local Time, not UTC.

mikemod

EXEC dbo.MyPRoc @startDate = '2023-12-12 15:36:22', -- datetime

                @endDate = '2023-12-12 15:36:22';   -- datetime

It is 9:36 AM Local Time

Dan_J

Hi @mikemod

Thanks for reaching out to us regarding this.

The behavior you are seeing is expected. SQL Prompt uses the default time value of UTC. They are however going to review this and will give me an update as soon as a decision is reached. 

I will come back to you on this again as soon as I have more information.

Dan_J

Hi there @mikemod

Thanks for your patience with us as our development team discussed this.

I've now heard back from them and unfortunately they are not going to be able to change the existing behavior (defaulting to UTC) at this time.  The decision was initially made to default to UTC because in most cases it tends to be more universally useful.

I appreciate this isn't the outcome you were hoping for and so encourage you to post a feature request for this on our SQL Prompt UserVoice page (https://redgate.uservoice.com/forums/94413-sql-prompt). That way our development team will have visibility of it and can consider making this change in the future.