What are the challenges you face when working across database platforms? Take the survey
Options

Can I configure the DateTime to default to Local Time?

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

Answers

  • Options
    mikemodmikemod Posts: 5 Bronze 2
    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
  • Options
    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.
    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
  • Options
    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.


    Kind regards

    Dan Jary | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.