Functions.MonthsBetween Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| MonthsBetween(Column, Column) |
Returns number of months between dates |
| MonthsBetween(Column, Column, Boolean) |
Returns number of months between dates |
MonthsBetween(Column, Column)
Returns number of months between dates end and stasrt.
public static Microsoft.Spark.Sql.Column MonthsBetween(Microsoft.Spark.Sql.Column end, Microsoft.Spark.Sql.Column start);static member MonthsBetween : Microsoft.Spark.Sql.Column * Microsoft.Spark.Sql.Column -> Microsoft.Spark.Sql.ColumnPublic Shared Function MonthsBetween (end As Column, start As Column) As ColumnParameters
- end
- Column
Date column
- start
- Column
Date column
Returns
Column object
Applies to
MonthsBetween(Column, Column, Boolean)
Returns number of months between dates end and start. If roundOff is set to true,
the result is rounded off to 8 digits; it is not rounded otherwise.
[Microsoft.Spark.Since("2.4.0")]
public static Microsoft.Spark.Sql.Column MonthsBetween(Microsoft.Spark.Sql.Column end, Microsoft.Spark.Sql.Column start, bool roundOff);[<Microsoft.Spark.Since("2.4.0")>]
static member MonthsBetween : Microsoft.Spark.Sql.Column * Microsoft.Spark.Sql.Column * bool -> Microsoft.Spark.Sql.ColumnPublic Shared Function MonthsBetween (end As Column, start As Column, roundOff As Boolean) As ColumnParameters
- end
- Column
Date column
- start
- Column
Date column
- roundOff
- Boolean
To round or not
Returns
Column object
- Attributes