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
ON	Turns on display of time in DATE value.
OFF	Turns off display of time in DATE value [default].

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.

Tip: 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