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

Can I configure the DateTime to default to Local Time?

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

Comments

3 comments

Sort by
  • 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
    mikemod
    0
  • 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
    0
  • 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.


    Dan_J
    0

Add comment

Please sign in to leave a comment.