Class | Description |
---|---|
DateDifFunction |
This function returns the number of years, months, or days between two date numbers.
The Format is a code from the following table, entered as text, that specifies the format you want: format Returns the number of y Years m Months. |
DateDifFunctionDescription |
Describes DateDifFunction function.
|
DateFunction |
Creation-Date: 04.11.2006, 18:59:11
|
DateFunctionDescription |
Creation-Date: 04.11.2006, 18:59:11
|
DateTimeFunctionCategory |
Creation-Date: 05.11.2006, 14:30:36
|
DateTimeValueFunction |
This function returns
|
DateTimeValueFunctionDescription |
Describes DateValueFunction function.
|
DateValueFunction |
This function returns
|
DateValueFunctionDescription |
Describes DateValueFunction function.
|
DayFunction |
This function extracts the day from a date.
|
DayFunctionDescription |
Describes DayFunction function.
|
DaysFunction |
This is the same as DATEDIFF(date_1, date_2, "d");
|
DaysFunctionDescription |
Describes DayFunction function.
|
HourFunction |
This function extracts the hour (0 through 23) from a time.
|
HourFunctionDescription |
Describes HourFunction function.
|
MinuteFunction |
This function extracts the minute (0 through 59) from a time.
|
MinuteFunctionDescription |
Describes SecondFunction function.
|
MonthEndFunction |
This function calculates the last day of the month
|
MonthEndFunctionDescription |
Describes MonthEndFunction function.
|
MonthFunction |
This function extracts the month from a date.
|
MonthFunctionDescription |
Describes MonthFunction function.
|
NowFunction |
Return the serial number of the current date and time.
|
NowFunctionDescription |
Creation-Date: 04.11.2006, 18:59:11
|
PrevWeekdayFunction | |
PrevWeekdayFunctionDescription |
Creation-Date: 04.11.2006, 18:59:11
|
SecondFunction |
This function extracts the minute (0 through 59) from a time.
|
SecondFunctionDescription |
Describes SecondFunction function.
|
TimeFunction |
This fonction constructs a time from hours, minutes, and seconds.
|
TimeFunctionDescription |
Describes the TimeFunction function
|
TimeValueFunction |
This fonction constructs a time from hours, minutes, and seconds.
|
TimeValueFunctionDescription |
Describes the TimeFunction function
|
TodayFunction | |
TodayFunctionDescription |
Creation-Date: 04.11.2006, 18:59:11
|
WeekDayFunction |
This function extracts the day of week from a date.
|
WeekDayFunctionDescription |
Describes WeekDayFunction function.
|
YearFunction |
This function extracts the year from a date.
|
YearFunctionDescription |
Describes YearFunction function.
|
YesterdayFunction | |
YesterdayFunctionDescription |
Creation-Date: 04.11.2006, 18:59:11
|
Copyright © 2017 Hitachi Vantara. All rights reserved.