How to compare 2 java.sql.Date in scala?

Question

I have some date in format java.sql.Date and I want to compare them

import java.sql.Date
import org.apache.spark.sql.types.{DateType, IntegerType}
var a = Date.valueOf("2018-11-09")
var b = Date.valueOf("2019-11-09")

a: java.sql.Date = 2018-11-09
b: java.sql.Date = 2019-11-09

If I compare with an equal sign it work

a == b
res1: Boolean = false

But if I want to know which one is bigger than the other it return an error:

 a >= b
<console>:37: error: value > is not a member of java.sql.Date

I would expect it to return false.

How can I compare a and b.?

Tim Biegeleisen · Accepted Answer · 2018-11-16 13:43:29Z

4

You may use java.sql.Date#compareTo:

var a = Date.valueOf("2018-11-09")
var b = Date.valueOf("2019-11-09")

if (b.compareTo(a) > 0) {
    println("Date b is later than date a.");
}

answered Nov 16, 2018 at 13:43

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexey Romanov · Accepted Answer · 2018-11-16 17:20:43Z

3

If you want to use the comparison operators such as a >= b instead of compareTo, you can: just add

import scala.math.Ordering.Implicits._

for Comparable types. java.sql.Date is actually a bit unusual, because it's Comparable with java.util.Date and not java.sql.Date. So for this type you need type ascription:

(a: java.util.Date) >= b

edited Nov 16, 2018 at 17:20

answered Nov 16, 2018 at 13:45

Alexey Romanov

172k38 gold badges329 silver badges509 bronze badges

3 Comments

Alexey Romanov Over a year ago

OK, edited (I started writing my answer before yours appeared).

Anneso Over a year ago

Hi Alexey Romanov, thank you for your answer however it does not work with me..... I do the import "import scala.math.Ordering.Implicits._" but when I tried a>= b I still get the same error...

Alexey Romanov Over a year ago

@Anneso Edited it.

Collectives™ on Stack Overflow

How to compare 2 java.sql.Date in scala?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related