java.lang.Object
- com.clickhouse.client.data.ClickHouseObjectValue<LocalDateTime>
- - com.clickhouse.client.data.ClickHouseDateTimeValue

All Implemented Interfaces:

ClickHouseValue, Serializable
```
public class ClickHouseDateTimeValue
extends ClickHouseObjectValue<LocalDateTime>
```
Wraper class of LocalDateTime.

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type Field Description

static LocalDateTime DEFAULT
Default value.

Constructor Summary

Constructors
Modifier Constructor Description

protected ClickHouseDateTimeValue(LocalDateTime value, int scale, TimeZone tz)

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`BigDecimal`	`asBigDecimal(int scale)`	Gets value as `BigDecimal`.
`BigInteger`	`asBigInteger()`	Gets value as `BigInteger`.
`byte`	`asByte()`	Gets value as byte.
`LocalDate`	`asDate()`	Gets value as `LocalDate`.
`LocalDateTime`	`asDateTime(int scale)`	Gets value as `LocalDateTime`.
`double`	`asDouble()`	Gets value as double.
`float`	`asFloat()`	Gets value as float.
`Instant`	`asInstant(int scale)`	Gets value as `Instant`.
`int`	`asInteger()`	Gets value as integer.
`long`	`asLong()`	Gets value as long.
`Object`	`asObject()`	Gets value as an object.
`OffsetDateTime`	`asOffsetDateTime(int scale)`	Gets value as `OffsetDateTime`.
`short`	`asShort()`	Gets value as short.
`String`	`asString(int length, Charset charset)`	Gets value as fixed length(in bytes) string.
`ZonedDateTime`	`asZonedDateTime(int scale)`	Gets value as `ZonedDateTime`.
`ClickHouseDateTimeValue`	`copy(boolean deep)`	Gets a copy of this value object.
`int`	`getScale()`
`static ClickHouseDateTimeValue`	`of(ClickHouseValue ref, String value, int scale, TimeZone tz)`	Update value of the given object or create a new instance if `ref` is null.
`static ClickHouseDateTimeValue`	`of(ClickHouseValue ref, LocalDateTime value, int scale, TimeZone tz)`	Update value of the given object or create a new instance if `ref` is null.
`static ClickHouseDateTimeValue`	`of(String value, int scale, TimeZone tz)`	Wrap the given getValue().
`static ClickHouseDateTimeValue`	`of(LocalDateTime value, int scale, TimeZone tz)`	Wrap the given getValue().
`static ClickHouseDateTimeValue`	`ofNull(int scale, TimeZone tz)`	Create a new instance representing null getValue().
`static ClickHouseDateTimeValue`	`ofNull(ClickHouseValue ref, int scale, TimeZone tz)`	Update given value to null or create a new instance if `ref` is null.
`ClickHouseDateTimeValue`	`resetToDefault()`	Resets to default value of corresponding data type.
`String`	`toSqlExpression()`	Converts the value to escaped SQL expression.
`ClickHouseDateTimeValue`	`update(byte value)`	Updates value.
`ClickHouseDateTimeValue`	`update(double value)`	Updates value.
`ClickHouseDateTimeValue`	`update(float value)`	Updates value.
`ClickHouseDateTimeValue`	`update(int value)`	Updates value.
`ClickHouseDateTimeValue`	`update(long value)`	Updates value.
`ClickHouseDateTimeValue`	`update(short value)`	Updates value.
`ClickHouseDateTimeValue`	`update(ClickHouseValue value)`	Updates value.
`ClickHouseDateTimeValue`	`update(Enum<?> value)`	Updates value.
`ClickHouseDateTimeValue`	`update(Object value)`	Updates value.
`ClickHouseDateTimeValue`	`update(String value)`	Updates value.
`ClickHouseDateTimeValue`	`update(BigDecimal value)`	Updates value.
`ClickHouseDateTimeValue`	`update(BigInteger value)`	Updates value.
`ClickHouseDateTimeValue`	`update(Instant value)`	Updates value.
`ClickHouseDateTimeValue`	`update(LocalDate value)`	Updates value.
`ClickHouseDateTimeValue`	`update(LocalDateTime value)`	Updates value.
`ClickHouseDateTimeValue`	`update(LocalTime value)`	Updates value.
`ClickHouseValue`	`update(OffsetDateTime value)`	Updates value.
`ClickHouseValue`	`update(ZonedDateTime value)`	Updates value.

Methods inherited from class com.clickhouse.client.data.ClickHouseObjectValue
equals, getValue, hashCode, isNullOrEmpty, resetToNullOrEmpty, set, toString

Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.clickhouse.client.ClickHouseValue
asArray, asArray, asBigDecimal, asBinary, asBinary, asBinary, asBinary, asBoolean, asByteStream, asCharacter, asCharacterStream, asDateTime, asEnum, asInet4Address, asInet6Address, asInstant, asMap, asMap, asObject, asOffsetDateTime, asString, asString, asString, asTime, asTime, asTuple, asUuid, asZonedDateTime, copy, isInfinity, isNaN, newUnsupportedException, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, updateUnknown

- Field Detail
  - DEFAULT
```
public static final LocalDateTime DEFAULT
```
    Default value.
- Constructor Detail
  - ClickHouseDateTimeValue
```
protected ClickHouseDateTimeValue(LocalDateTime value,
                                  int scale,
                                  TimeZone tz)
```
- Method Detail
  - ofNull
```
public static ClickHouseDateTimeValue ofNull(int scale,
                                             TimeZone tz)
```
    Create a new instance representing null getValue().
    
    Parameters:
    
    scale - scale
    
    tz - time zone, null is treated as UTC
    
    Returns:
    
    new instance representing null value
  - ofNull
```
public static ClickHouseDateTimeValue ofNull(ClickHouseValue ref,
                                             int scale,
                                             TimeZone tz)
```
    Update given value to null or create a new instance if ref is null.
    
    Parameters:
    
    ref - object to update, could be null
    
    scale - scale, only used when ref is null
    
    tz - time zone, null is treated as UTC
    
    Returns:
    
    same object as ref or a new instance if it's null
  - of
```
public static ClickHouseDateTimeValue of(LocalDateTime value,
                                         int scale,
                                         TimeZone tz)
```
    Wrap the given getValue().
    
    Parameters:
    
    value - value
    
    scale - scale
    
    tz - time zone, null is treated as UTC
    
    Returns:
    
    object representing the value
  - of
```
public static ClickHouseDateTimeValue of(String value,
                                         int scale,
                                         TimeZone tz)
```
    Wrap the given getValue().
    
    Parameters:
    
    value - UTC date time in string
    
    scale - scale
    
    tz - time zone, null is treated as UTC
    
    Returns:
    
    object representing the value
  - of
```
public static ClickHouseDateTimeValue of(ClickHouseValue ref,
                                         LocalDateTime value,
                                         int scale,
                                         TimeZone tz)
```
    Update value of the given object or create a new instance if ref is null.
    
    Parameters:
    
    ref - object to update, could be null
    
    value - value
    
    scale - scale, only used when ref is null
    
    tz - time zone, null is treated as UTC
    
    Returns:
    
    same object as ref or a new instance if it's null
  - of
```
public static ClickHouseDateTimeValue of(ClickHouseValue ref,
                                         String value,
                                         int scale,
                                         TimeZone tz)
```
    Update value of the given object or create a new instance if ref is null.
    
    Parameters:
    
    ref - object to update, could be null
    
    value - UTC date time in string
    
    scale - scale
    
    tz - time zone, null is treated as UTC
    
    Returns:
    
    same object as ref or a new instance if it's null
  - getScale
```
public int getScale()
```
  - copy
```
public ClickHouseDateTimeValue copy(boolean deep)
```
    Description copied from interface: ClickHouseValue
    
    Gets a copy of this value object.
    
    Parameters:
    
    deep - true to create a deep copy; false for a shallow copy
    
    Returns:
    
    copy of this value object
  - asByte
```
public byte asByte()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as byte.
    
    Specified by:
    
    asByte in interface ClickHouseValue
    
    Overrides:
    
    asByte in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    byte value
  - asShort
```
public short asShort()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as short.
    
    Specified by:
    
    asShort in interface ClickHouseValue
    
    Overrides:
    
    asShort in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    short value
  - asInteger
```
public int asInteger()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as integer.
    
    Specified by:
    
    asInteger in interface ClickHouseValue
    
    Overrides:
    
    asInteger in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    integer value
  - asLong
```
public long asLong()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as long.
    
    Specified by:
    
    asLong in interface ClickHouseValue
    
    Overrides:
    
    asLong in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    long value
  - asFloat
```
public float asFloat()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as float.
    
    Specified by:
    
    asFloat in interface ClickHouseValue
    
    Overrides:
    
    asFloat in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    float value
  - asDouble
```
public double asDouble()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as double.
    
    Specified by:
    
    asDouble in interface ClickHouseValue
    
    Overrides:
    
    asDouble in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    double value
  - asBigInteger
```
public BigInteger asBigInteger()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as BigInteger.
    
    Specified by:
    
    asBigInteger in interface ClickHouseValue
    
    Overrides:
    
    asBigInteger in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    big integer, could be null
  - asBigDecimal
```
public BigDecimal asBigDecimal(int scale)
```
    Description copied from interface: ClickHouseValue
    
    Gets value as BigDecimal.
    
    Specified by:
    
    asBigDecimal in interface ClickHouseValue
    
    Overrides:
    
    asBigDecimal in class ClickHouseObjectValue<LocalDateTime>
    
    Parameters:
    
    scale - scale of the decimal
    
    Returns:
    
    big decimal, could be null
  - asDate
```
public LocalDate asDate()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as LocalDate.
    
    Returns:
    
    date, could be null
  - asDateTime
```
public LocalDateTime asDateTime(int scale)
```
    Description copied from interface: ClickHouseValue
    
    Gets value as LocalDateTime.
    
    Parameters:
    
    scale - scale of the date time, between 0 (second) and 9 (nano second)
    
    Returns:
    
    date time, could be null
  - asInstant
```
public Instant asInstant(int scale)
```
    Description copied from interface: ClickHouseValue
    
    Gets value as Instant.
    
    Parameters:
    
    scale - scale of the date time, between 0 (second) and 9 (nano second)
    
    Returns:
    
    instant, could be null
  - asOffsetDateTime
```
public OffsetDateTime asOffsetDateTime(int scale)
```
    Description copied from interface: ClickHouseValue
    
    Gets value as OffsetDateTime.
    
    Parameters:
    
    scale - scale of the date time, between 0 (second) and 9 (nano second)
    
    Returns:
    
    date time, could be null
  - asZonedDateTime
```
public ZonedDateTime asZonedDateTime(int scale)
```
    Description copied from interface: ClickHouseValue
    
    Gets value as ZonedDateTime.
    
    Parameters:
    
    scale - scale of the date time, between 0 (second) and 9 (nano second)
    
    Returns:
    
    date time, could be null
  - asObject
```
public Object asObject()
```
    Description copied from interface: ClickHouseValue
    
    Gets value as an object.
    
    Specified by:
    
    asObject in interface ClickHouseValue
    
    Overrides:
    
    asObject in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    an object representing the value, could be null
  - asString
```
public String asString(int length,
                       Charset charset)
```
    Description copied from interface: ClickHouseValue
    
    Gets value as fixed length(in bytes) string.
    
    Specified by:
    
    asString in interface ClickHouseValue
    
    Overrides:
    
    asString in class ClickHouseObjectValue<LocalDateTime>
    
    Parameters:
    
    length - byte length of the string, 0 or negative number means unbounded
    
    charset - charset, null is same as default(UTF-8)
    
    Returns:
    
    string value, could be null
  - resetToDefault
```
public ClickHouseDateTimeValue resetToDefault()
```
    Description copied from interface: ClickHouseValue
    
    Resets to default value of corresponding data type.
    
    Returns:
    
    this object
  - toSqlExpression
```
public String toSqlExpression()
```
    Description copied from interface: ClickHouseValue
    
    Converts the value to escaped SQL expression. For example, number 123 will be converted to 123, while string "12'3" will be converted to @{code '12\'3'}.
    
    Specified by:
    
    toSqlExpression in interface ClickHouseValue
    
    Overrides:
    
    toSqlExpression in class ClickHouseObjectValue<LocalDateTime>
    
    Returns:
    
    escaped SQL expression
  - update
```
public ClickHouseDateTimeValue update(byte value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(short value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(int value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(long value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(float value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(double value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(BigInteger value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(BigDecimal value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(Enum<?> value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(LocalDate value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(LocalTime value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(LocalDateTime value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(Instant value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseValue update(OffsetDateTime value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseValue update(ZonedDateTime value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(String value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(ClickHouseValue value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value.
    
    Parameters:
    
    value - value to update
    
    Returns:
    
    this object
  - update
```
public ClickHouseDateTimeValue update(Object value)
```
    Description copied from interface: ClickHouseValue
    
    Updates value. This method tries to identify type of value and then use corresponding update method to proceed. Unknown value will be passed to ClickHouseValue.updateUnknown(Object).
    
    Specified by:
    
    update in interface ClickHouseValue
    
    Overrides:
    
    update in class ClickHouseObjectValue<LocalDateTime>
    
    Parameters:
    
    value - value to update, could be null
    
    Returns:
    
    this object

Class ClickHouseDateTimeValue

Field Summary

Constructor Summary

Method Summary

Methods inherited from class com.clickhouse.client.data.ClickHouseObjectValue

Methods inherited from class java.lang.Object

Methods inherited from interface com.clickhouse.client.ClickHouseValue

Field Detail

DEFAULT

Constructor Detail

ClickHouseDateTimeValue

Method Detail

ofNull

ofNull

of

of

of

of

getScale

copy

asByte

asShort

asInteger

asLong

asFloat

asDouble

asBigInteger

asBigDecimal

asDate

asDateTime

asInstant

asOffsetDateTime

asZonedDateTime

asObject

asString

resetToDefault

toSqlExpression

update

update

update

update

update

update

update

update

update

update

update

update

update

update

update

update

update

update