Parses column as array.
Parses column as array.
val a: Array[String] = SQL"SELECT str_arr FROM tbl".as(scalar[Array[String]]) }}}
Column conversion to big integer.
Column conversion to big integer.
import anorm.SqlParser.scalar import anorm.Column.columnToBigInt val c: BigInt = SQL("SELECT COUNT(*) FROM tbl").as(scalar[BigInt].single)
Column conversion to Java big integer.
Column conversion to Java big integer.
import anorm.SqlParser.scalar import anorm.Column.columnToScalaBigInteger val c: BigInteger = SQL("SELECT COUNT(*) FROM tbl").as(scalar[BigInteger].single)
Column conversion to bytes array.
Column conversion to bytes array.
import anorm.SqlParser.scalar import anorm.Column.columnToByteArray val bytes: Array[Byte] = SQL("SELECT bin FROM tbl"). as(scalar[Array[Byte]].single)
Column conversion to character.
Column conversion to character.
import anorm.SqlParser.scalar import anorm.Column.columnToChar val c: Char = SQL("SELECT char FROM tbl").as(scalar[Char].single)
Parses column as Java Date.
Parses column as Java Date.
Time zone offset is the one of default JVM time zone
(see java.util.TimeZone.getDefault
).
import java.util.Date val d: Date = SQL("SELECT last_mod FROM tbl").as(scalar[Date].single)
Column conversion to bytes array.
Column conversion to bytes array.
import anorm.SqlParser.scalar import anorm.Column.columnToInputStream val bytes: InputStream = SQL("SELECT bin FROM tbl"). as(scalar[InputStream].single)
Parses column as Java8 instant.
Parses column as Java8 instant.
Time zone offset is the one of default JVM time zone
(see java.time.ZoneId.systemDefault
).
import java.time.Instant import anorm.Java8._ val i: Instant = SQL("SELECT last_mod FROM tbl").as(scalar[Instant].single)
Column conversion to Java big decimal.
Column conversion to Java big decimal.
import java.math.{ BigDecimal => JBigDecimal } import anorm.SqlParser.scalar import anorm.Column.columnToJavaBigDecimal val c: JBigDecimal = SQL("SELECT COUNT(*) FROM tbl").as(scalar[JBigDecimal].single)
Parses column as joda DateTime
Parses column as joda DateTime
import org.joda.time.DateTime val d: Date = SQL("SELECT last_mod FROM tbl").as(scalar[DateTime].single)
Parses column as joda Instant
Parses column as joda Instant
import org.joda.time.Instant val d: Date = SQL("SELECT last_mod FROM tbl").as(scalar[Instant].single)
Parses column as Joda local date.
Parses column as Joda local date.
Time zone is the one of default JVM time zone
(see org.joda.time.DateTimeZone.getDefault
).
import org.joda.time.LocalDate val i: LocalDate = SQL("SELECT last_mod FROM tbl"). as(scalar[LocalDate].single)
Parses column as Joda local date/time.
Parses column as Joda local date/time.
Time zone is the one of default JVM time zone
(see org.joda.time.DateTimeZone.getDefault
).
import org.joda.time.LocalDateTime val i: LocalDateTime = SQL("SELECT last_mod FROM tbl"). as(scalar[LocalDateTime].single)
Parses column as list.
Parses column as list.
val a: List[String] = SQL"SELECT str_arr FROM tbl".as(scalar[List[String]]) }}}
Parses column as Java8 local date.
Parses column as Java8 local date.
Time zone offset is the one of default JVM time zone
(see java.time.ZoneId.systemDefault
).
import java.time.LocalDateTime import anorm.Java8._ val i: LocalDateTime = SQL("SELECT last_mod FROM tbl"). as(scalar[LocalDateTime].single)
Parses column as Java8 local date/time.
Parses column as Java8 local date/time.
Time zone offset is the one of default JVM time zone
(see java.time.ZoneId.systemDefault
).
import java.time.LocalDateTime import anorm.Java8._ val i: LocalDateTime = SQL("SELECT last_mod FROM tbl"). as(scalar[LocalDateTime].single)
Column conversion to big decimal.
Column conversion to big decimal.
import anorm.SqlParser.scalar import anorm.Column.columnToScalaBigDecimal val c: BigDecimal = SQL("SELECT COUNT(*) FROM tbl").as(scalar[BigDecimal].single)
Parses column as Java8 zoned date/time.
Parses column as Java8 zoned date/time.
Time zone offset is the one of default JVM time zone
(see java.time.ZoneId.systemDefault
).
import java.time.ZonedDateTime import anorm.Java8._ val i: ZonedDateTime = SQL("SELECT last_mod FROM tbl"). as(scalar[ZonedDateTime].single)
Helper function to implement column conversion.
Helper function to implement column conversion.
Function converting raw value of column
Resolves the Column
instance for the given type.
Resolves the Column
instance for the given type.
(equivalent to implicitly[Column[A]]
).
the type of the column value
import anorm.Column val resolved: Column[String] = Column.of[String]
(Since version 2.5.1) Use nonNull
Column companion, providing default conversions.