Selecting "Now" uses local time zone

Toad for Oracle & DevOps Toolkit
1

Our servers and databases are in UTC(0)--basically universal time with no time zone.

select dbtimezone from dual;

DBTIMEZONE
----------
UTC

When I use Schema Browser to create a row with a date column and use the pull-down tool to enter a date/time like this:

image
image860×459 10.4 KB

If I click "Now", the information that is entered is my local date and time and does not convert to UTC.

Now, this may just be the way it has to work. It may be that it cannot convert the time to the database's time zone, but I want to be sure. So, is it the case that "Now" will always be just my workstation's clock date/time?

Cheers,
Russ

2

Yeah, "Now" is the local time. I can't do anything about that in the popup control.

You can, however, just type sysdate into the grid (or an expression that contains sysdate), and Toad will run that and put the result into the grid.

Oh, and I just remembered - if you double-click the cell instead of click the dropdown arrow, you get this dialog instead which has a sysdate button

image
image511×359 34 KB

3

Excellent! That gets it. Thank you sir.

Cheers,
Russ

4

I never knew it was possible to do something like 'sysdate-1' in there. That is great!

Toad is the best software in the world, and Quest gives the best product support. You peeps are a great team.

Cheers,
Russ