Functions.MonthsBetween Method

Definition

Namespace:

Microsoft.Spark.Sql

Assembly:

Microsoft.Spark.dll

Package:

Microsoft.Spark v1.0.0

Overloads

MonthsBetween(Column, Column)	Returns number of months between dates end and stasrt.
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.

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.Column

Public Shared Function MonthsBetween (end As Column, start As Column) As Column

Parameters

end

Column

Date column

start

Column

Date column

Returns

Column

Column object

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.Column

Public Shared Function MonthsBetween (end As Column, start As Column, roundOff As Boolean) As Column

Parameters

end

Column

Date column

start

Column

Date column

roundOff

Boolean

To round or not

Returns

Column

Column object

Attributes

SinceAttribute