Play 2.6.11 Joda DateTime ISODate Issue

23 views
Skip to first unread message

William Beh

unread,
Jan 22, 2018, 8:44:02 PM1/22/18
to Play Framework

I'm using play 2.6 and reactivemongo. I'm having issue with ISODate. On mongodb the date is currently store as ISODate.

I keep getting this error

[JsResultException: JsResultException(errors:List((/sys/cdat,List(JsonValidationError(List(error.expected.date),WrappedArray())))))]

The class I used

case class System (
   eid: Option[String],
   cdat: Option[DateTime],
   mby: Option[String],
   dby: Option[String]
)

case class Company (
    _id: BSONObjectID,
    c: String,
    ct: String,
    sys: Option[System]
)

object CompanyFormats{
   import play.api.libs.json._

    val pattern = "yyyy-MM-dd'T'HH:mm:ss.SSSZ"
   implicit val dateFormat = Format[DateTime](JodaReads.jodaDateReads(pattern), JodaWrites.jodaDateWrites(pattern))
   implicit val systemFormat = Json.format[System]

    implicit val companyFormat: OFormat[Company] = Json.format[Company]
}

Appreciate help. I tried a few different format but still getting the same error.

Reply all
Reply to author
Forward
0 new messages