Filemaker TH325Z/A Ficha Técnica Página 203
- Página / 238
- Índice
- MARCADORES
Avaliado. / 5. Com base em avaliações de clientes
Chapter 14
|
Time functions 203
Seconds
Format
Seconds(time)
Parameter
time - any time value or field of type time
Data type returned
number
Description
Returns a number representing the number of seconds in time.
Examples
Seconds(“12:15:23”) returns 23.
Hour(Duration) + (Minute(Duration)/60) + (Seconds(Duration)/3600
returns 2.504166, if the Duration time field contains 2:30:15.
Time
Format
Time(hours;minutes;seconds)
Parameters
hours - the hour value of a time
minutes - the minutes value of a time
seconds - the seconds value of a time
Data type returned
time
Description
Returns a time result with the specified number of hours, minutes, and seconds.
FileMaker Pro compensates when you supply fractional hours or minutes. The result is
the time, formatted according to the time format of the field in the current layout.
Use the Time function or the GetAsTime function to enter a time constant
into a formula.
- FileMaker 1
- Contents 3
- Contents 5 5
- Logical functions 127 6
- Contents 7 7
- Text functions 161 8
- Contents 9 9
- Chapter 1 11
- Introduction 11
- Introduction 13 13
- H, I, J, K 14
- L, M, N, O 15
- V, W, X, Y, Z 16
- Chapter 2 17
- Aggregate functions 17
- Aggregate functions 19 19
- Aggregate functions 21 21
- Aggregate functions 23 23
- Variance 27
- VarianceP 28
- Chapter 3 31
- Date functions 31
- Date functions 33 33
- DayNameJ 34
- DayOfWeek 34
- DayOfYear 35
- MonthName 36
- MonthNameJ 36
- WeekOfYear 37
- WeekOfYearFiscal 37
- YearName 39
- Chapter 4 41
- Design functions 41
- DatabaseNames 43
- FieldBounds 43
- FieldComment 44
- FieldIDs 45
- FieldNames 45
- FieldRepetitions 46
- FieldStyle 47
- FieldType 48
- GetNextSerialValue 49
- LayoutIDs 49
- LayoutNames 50
- LayoutObjectNames 50
- RelationInfo 51
- ScriptIDs 52
- ScriptNames 53
- TableIDs 53
- TableNames 54
- ValueListIDs 54
- ValueListItems 55
- ValueListNames 55
- WindowNames 56
- Chapter 5 57
- External functions 57
- External 58
- Chapter 6 59
- Financial functions 59
- Chapter 7 63
- Get functions 63
- Get functions 65 65
- Get functions 67 67
- Get(AccountName) 68
- Get(ActiveFieldContents) 68
- Get(ActiveFieldName) 69
- Get(ActiveFieldTableName) 69
- Get(ActiveLayoutObjectName) 70
- Get(ActiveModifierKeys) 71
- Get(ActiveRepetitionNumber) 71
- Get(ActiveSelectionSize) 72
- Get(ActiveSelectionStart) 72
- Get(AllowAbortState) 73
- Get(AllowToolbarState) 73
- Get(ApplicationLanguage) 74
- Get(ApplicationVersion) 75
- Get(CurrentDate) 76
- Get(CurrentHostTimestamp) 76
- Get(CurrentTime) 77
- Get(CurrentTimestamp) 78
- Get(CustomMenuSetName) 78
- Get(DesktopPath) 79
- Get(DocumentsPath) 80
- Get(ErrorCaptureState) 80
- Get(ExtendedPrivileges) 81
- Get(FileMakerPath) 81
- Get(FileName) 82
- Get(FilePath) 82
- Get(FileSize) 83
- Get(FoundCount) 84
- Get(HighContrastColor) 84
- Get(HighContrastState) 85
- Get(HostIPAddress) 85
- Get(HostName) 86
- Get(LastError) 87
- Runtime errors 88
- Get functions 89 89
- Get functions 91 91
- Get(LastMessageChoice) 93
- Get(LastODBCError) 94
- Get(LayoutAccess) 94
- Get(LayoutCount) 95
- Get(LayoutName) 96
- Get(LayoutNumber) 96
- Get(LayoutTableName) 97
- Get(LayoutViewState) 97
- Get(MultiUserState) 98
- Get(NetworkProtocol) 99
- Get(PageNumber) 99
- Get(PortalRowNumber) 100
- Get(PreferencesPath) 100
- Get(PrinterName) 101
- Get(PrivilegeSetName) 102
- Get(RecordAccess) 102
- Get(RecordID) 103
- Get(RecordModificationCount) 104
- Get(RecordOpenCount) 105
- Get(RecordNumber) 105
- Get(RecordOpenState) 106
- Get(RequestCount) 107
- Get(RequestOmitState) 107
- Get(ScreenDepth) 108
- Get(ScreenHeight) 108
- Get(ScreenWidth) 109
- Get(ScriptName) 109
- Get(ScriptParameter) 110
- Get(ScriptResult) 111
- Get(SortState) 112
- Get(StatusAreaState) 112
- Get(SystemDrive) 113
- Get(SystemIPAddress) 114
- Get(SystemLanguage) 114
- Get(SystemNICAddress) 115
- Get(SystemPlatform) 115
- Get(SystemVersion) 116
- Get(TextRulerVisible) 116
- Get(TotalRecordCount) 117
- Get(UserCount) 117
- Get(UserName) 118
- Get(UseSystemFormatsState) 119
- Get(WindowContentHeight) 119
- Get(WindowContentWidth) 120
- Get(WindowDesktopHeight) 120
- Get(WindowDesktopWidth) 121
- Get(WindowHeight) 122
- Get(WindowLeft) 122
- Get(WindowMode) 123
- Get(WindowName) 123
- Get(WindowTop) 124
- Get(WindowVisible) 125
- Get(WindowWidth) 125
- Get(WindowZoomLevel) 126
- Chapter 8 127
- Logical functions 127
- Evaluate 129
- EvaluationError 131
- GetAsBoolean 131
- GetField 132
- GetLayoutObjectAttribute 133
- GetNthRecord 134
- Logical functions 135 135
- IsValidExpression 137
- Logical functions 139 139
- LookupNext 141
- 1 to 4 142
- Chapter 9 143
- Number functions 143
- Combination 145
- Factorial 146
- Number functions 147 147
- Ln number() 148
- SetPrecision 151
- Truncate 153
- Chapter 10 155
- Repeating functions 155
- GetRepetition 156
- Repeating functions 157 157
- Chapter 11 159
- Summary functions 159
- GetSummary 160
- Chapter 12 161
- Text functions 161
- Text functions 163 163
- FilterValues 164
- GetAsCSS 165
- GetAsDate 166
- GetAsNumber 166
- GetAsSVG 167
- GetAsText 168
- GetAsTime 168
- GetAsTimestamp 169
- GetAsURLEncoded 169
- GetValue 170
- Hiragana 171
- KanaHankaku 171
- KanaZenkaku 172
- KanjiNumeral 172
- Katakana 172
- LeftValues 173
- LeftWords 174
- Text functions 175 175
- MiddleValues 176
- MiddleWords 177
- NumToJText 178
- PatternCount 179
- Position 179
- Text functions 181 181
- RightValues 182
- RightWords 183
- RomanHankaku 184
- RomanZenkaku 184
- SerialIncrement 185
- Substitute 186
- Text functions 187 187
- ValueCount 189
- WordCount 189
- Chapter 13 191
- Text formatting functions 191
- TextColor 192
- TextColorRemove 193
- TextFont 194
- TextFontRemove 195
- TextFormatRemove 196
- TextSize 197
- TextSizeRemove 197
- TextStyleAdd 198
- TextStyleRemove 199
- Chapter 14 201
- Time functions 201
- Time functions 203 203
- Examples 204
- Chapter 15 205
- Timestamp functions 205
- Timestamp 206
- Chapter 16 207
- Trigonometric functions 207
- Appendix A 213
- Glossary 213
- Glossary 215 215
- Glossary 217 217
- Glossary 219 219
- Glossary 221 221
- Glossary 223 223
- Glossary 225 225
- Glossary 227 227
- Glossary 229 229
- Glossary 231 231
- Glossary 233 233
- Glossary 235 235
- W, X, Y, Z 237
Manuais e produtos relacionados com Software de bases de dados Filemaker TH325Z/A
(21 páginas)© 2020, manymanuals-pt.com. Todos os direitos reservados. | 0.051 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentários a estes Manuais