SET TIME
Go Up to isql Command Reference
Specifies whether to display the time portion of a DATE value.
SET TIME [ON | OFF];
| Argument | Description |
|---|---|
|
|
Turns on display of time in |
|
|
Turns off display of time in |
Description: The InterBase Date data type includes a date portion (including day, month, and year) and a time portion (including hours, minutes, and seconds).
By default, isql displays only the date portion of Date values. SET TIME ON turns on the display of time values. SET TIME OFF turns off the display of time values.
The
ON and OFF keywords are optional. If they are omitted, the command toggles time display from ON to OFF or OFF to ON.Example: The following example shows the default display of a DATE data type, which is to display day, month, and year:
SELECT HIRE_DATE FROM EMPLOYEE WHERE EMP_NO = 145;
HIRE_DATE
-------------------
2-MAY-1994
This example shows the effects of SET TIME ON, which causes the hours, minutes and seconds to be displayed as well:
SET TIME ON;
SELECT HIRE_DATE FROM EMPLOYEE WHERE EMP_NO = 145;
HIRE_DATE
-------------------
2-MAY-1994 12:25:00