Convert HH: mm: ss in seconds

Question

I use the following script to extract HH: mm: ss from the date format yyy-MM-dd HH: mm: ss

import java.sql.Time

case class Transactions(creationTime: Time)

val formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")

def parseTransac(line: String): (Transactions) = {
   val fields = line.split(',')
   val creationTime = new Time(formatter.parse(fields(0)).getTime())
   val transactions = Transactions(creationTime)
   (transactions)
}

So, for example, 2009-01-15 15:45:23will return 15:45:23.

How to get the result in seconds (56723) instead of HH: mm: ss

Answer 1

Based on Jesper's suggestion, here is a solution:

import java.sql.Time    

case class Transactions(creationSeconds: Int )

val formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")

def parseTransac(line: String): (Transactions) = {
   val fields = line.split(',')
   val fullDateTime = new Time(formatter.parse(fields(0)).getTime())
   val creationTime = fullDateTime.toString.split(':')
   val creationSeconds = creationTime(0).toInt*3600 + creationTime(1).toInt*60 + creationTime(2).toInt
   val transactions = Transactions(creationSeconds)
   (transactions)
}

and here is another solution based on the Dipankar hint:

import java.sql.Time
import org.joda.time.DateTime

case class Transactions(creationTime: Int)

val formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")

def parseTransac(line: String): (Transactions) = {
   val fields = line.split(',')
   val fullDatTime = new DateTime(formatter.parse(fields(0)).getTime())
   val fromMidnight = fullDatTime.withTimeAtStartOfDay()
   val duration = new Duration(fromMidnight, fullDatTime)
   val creationTime = duration.toStandardSeconds().getSeconds()
   val transactions = Transactions(creationTime)
   (transactions)
}

Answer 2

You can also do this with a simple regular expression.

case class Transactions(creationTime: Int)

val format = "\\d{4}-\\d{2}-\\d{2}\\s(\\d{1,2}):(\\d{1,2}):(\\d{1,2})".r

def parseTransac(line: String): (Transactions) = {
  val fields = line.split(',')

  val format(h, m, s) = fields(0)

  Transactions(s.toInt + m.toInt * 60 + h.toInt * 3600)
}

Answer 3

:

scala> "15:45:23".split(":").map(_.toInt).reduceLeft((x,y) => x*60 +y)
res0: Int = 56723