Date and Time Editing

Previous  Top  Next

When you can enter a date or time value, Database Workbench provides you with easy-to-use editor controls.

 

Editing Date

Where you can edit a date value, there's a drop-down arrow. If you click it, a small calendar pops up. Today's date is marked by a red rectangle around the date. You can select a new date from the drop-down calendar directly or change the "current" month by using the arrows in the top left and top right corner. You can also modify the month by clicking the month name and selecting a new month from the menu that pops up. In addition to that, the year can be modified by clicking it and using the arrow keys that show up then.

 

Select a date to accept the value or use the ESC button on your keyboard to cancel the change. If you click outside the calendar popup, the value will be canceled as well.

 

Editing date

 

Editing Time

Where you can edit a time value, there's a drop-down arrow. If you click it, a clock shows up. As you can see, you can use the left mouse button to set the hour value and the right mouse button to set the minute value. You can drag the big hand and little hand around when pressing the mouse buttons.

 

Use the Set button to accept the value or use the ESC button on your keyboard to cancel the change. If you click outside the clock popup, the value will be canceled as well.

 

Editing time