The date within the variable is formatted as dd/mm/yyyyy. There is no time setting associated with that date. When using Toad For Data Analysts, the dates always appeared with a default time of 12:00:00 AM because there is no time data. The datetime format under Tools | Options | Environment | Grid | DateTime Format aren't being applied. Short Date(d) format usually works to set with only date and no time, but it is not working in 2.6.
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Data Analysts.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy