Time Tab

Use the Time tab to select time-related functions that allow you to:

  • Convert between Fractional time and Second time

  • Extract time components from Fractional time

For more information on time formats, see the Application Notes below.    

Each tab item includes a tooltip that shows the required arguments and a brief description of the function.

Time Tab options   

Button

Syntax

Definition

Time Conversion

../../../../geohelp/image/1date1.jpg Fractional time (HH.hh)

 

time(hour,minute,second)

 

Converts (Hours,Minutes,Seconds) to Fractional time.

Extract from Fractional Time

../../../../geohelp/image/1date2.jpg Hour (HH)

time_hour(fractional time)

Extracts Hour from Fractional time.

../../../../geohelp/image/1date2.jpg Minute (MM)

time_minute(fractional time)

Extracts Minute from Fractional time.

../../../../geohelp/image/1date2.jpg Second (SS.ss)

time_second(fractional time)

Extracts Second from Fractional time.

Convert Exact Second Time

../../../../geohelp/image/1date3.jpg Fractional time (HH.hh)

time_from_long(days)

Converts Exact Second Time to Fractional time.

../../../../geohelp/image/1date2.jpg Integer second (SSSS)

time_to_long(fractional time)

Converts Fractional time to Exact Second time.

Convert Fractional Second Time

../../../../geohelp/image/1date3.jpg Fractional time (HH.hh)

time_from_seconds(days)

Converts Fractional Second time to Fractional time.

../../../../geohelp/image/1date2.jpg Second time (SSSS.ss)

time_to_seconds(fractional time)

Converts Fractional time to Fractional Second time.

Application Notes

Fractional Time

Represents the time of day in decimal hours.

Example:

4:15:34.35 is stored as:

Second Time

Represents the elapsed seconds in a day, ranging from 0 to 86400.

Stored in two forms:

  • Exact: Whole seconds

  • Fractional: Partial seconds supported

Example:

4:15:34.35 is stored as: