play.json formatter for java.sql.Timestamp and java.time.LocalDateTime

TimestampFormat.scala

package models.database
import java.sql.Timestamp
import java.text.SimpleDateFormat
import java.time.LocalDateTime
import java.time.format.DateTimeFormatter

import play.api.libs.json.{Format, JsString, JsSuccess, JsValue}

object Common {

  implicit object timestampFormat extends Format[Timestamp] {
    val format = DateTimeFormatter.ofPattern("yyyy-MM-dd'T'HH:mm:ss.SS'Z'")
    def reads(json: JsValue) = {
      val str = json.as[String]
      val ldt=LocalDateTime.parse(str,format)
      JsSuccess(Timestamp.valueOf(ldt))
    }
    def writes(ts: Timestamp) = JsString(format.format(ts.toLocalDateTime))
  }

  implicit object localDateTimeFormat extends Format[LocalDateTime] {
    val format = DateTimeFormatter.ofPattern("yyyy-MM-dd'T'HH:mm:ss.SS'Z'")
    def reads(json: JsValue) = {
      val str = json.as[String]
      val ldt=LocalDateTime.parse(str,format)
      JsSuccess(ldt)
    }
    def writes(localDateTime: LocalDateTime) = JsString(format.format(localDateTime))
  }
}