Results 1 to 9 of 9

Thread: CurrentDateTime, SQL and 24/12 hour display

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default CurrentDateTime, SQL and 24/12 hour display

    Hi, I have a table with a column that is set as DateTime using native DateTime.

    if I save to it from a server/computer with the regional settings set to display 24 hours it will save to that field something like: "1/23/2021 16:20:38.668"
    if I save to it from a server/computer with the regional settings set to display 12 hours it will save to that field something like: "1/23/2021 4:20:38.668"

    They both display the same when just output the CurrentDateTime() to a label: "1/23/2021 4:20:38,668 PM"
    (Edit: after changing the regional settings and restarting the server it display "1/23/2021 16:20:38,668 PM" so the problem is only the saving)

    not sure if I am missing any setting on the webapp to make it work correctly regardless of the server setting.

    Thank you,
    Oscar
    Last edited by Oscar; 23-Jan-2021 at 04:33 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •