Convert HH:mm:ss in seconds

Question

I am using the following script to extract HH:mm:ss from a yyyy-MM-dd HH:mm:ss date format

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 instance 2009-01-15 15:45:23 will return 15:45:23.

How can I obtain the result in seconds (56723) instead of HH:mm:ss

Parse the string into hours, minutes and seconds (split on `:` and parse to `Int`) and then `3600 * hours + 60 * minutes + seconds`. — Jesper, Jan 07 '16 at 08:35
Please Check this Link: http://stackoverflow.com/questions/4389500/how-can-i-find-the-amount-of-seconds-passed-from-the-midnight-with-java — Dipankar Banik, Jan 07 '16 at 08:46

ulrich · Accepted Answer · 2016-01-07T11:44:14.367

Based on Jesper's suggestion, here is the 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 Dipankar's 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)
}

grzesiekw · Answer 2 · 2016-01-07T19:47:19.430

1

You can also do this with simple regex.

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)
}

edited Jan 07 '16 at 19:47

answered Jan 07 '16 at 19:40

grzesiekw

477
4
8

score 1 · Answer 3 · answered Sep 04 '17 at 10:55

1

A quick one liner:

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

answered Sep 04 '17 at 10:55

geo

516
5
12

Convert HH:mm:ss in seconds

3 Answers3

Linked