Progress
Embedded SQL-92
Guide and Reference
TIME Data Type
The TIME data type corresponds to the time value with four parts: hours, minutes, seconds, and milliseconds. The database representation is a long integer. The host language representation is equivalent to the following C Language structure:
The hours range is 0 to 23. The minutes range is 0 to 59. The range for the seconds part is 0 to 59. The milliseconds range is 0 to 999.
EXAMPLEThe following example shows how to use the TIME data type:
Some of the scalar functions available for manipulating TIME data are TO_TIME, HOUR, MINUTE, SECOND, etc. See Chapter 4, “SQL-92 Functions,” in the Progress SQL-92 Guide and Reference for additional information on scalar functions.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |