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