secondOfDay

secondOfDay returns the number of seconds that have elapsed since the top of the day (midnight) for the specified date-time.

Syntax

Parameters

ParameterTypeDescription
instantInstant

The date-time from which to return the number of seconds.

timeZoneZoneId

The time zone.

dateTimeZonedDateTime

The date-time from which to return the number of seconds.

asLocalTimeboolean

Set this parameter to false if you need Deephaven to account for daylight savings time.

  • If false, returns the number of seconds from the start of the day. However, on days when daylight savings time events occur, results may be different from what is expected based on the local time. For example, on DST change days, 9:30 AM may be earlier or later in the day based on whether the daylight savings time adjustment is forward or backward.
  • If true, returns the number of seconds from the start of the day according to the local time. In this case, 9:30 will always return the same value.

On non-DST days, the result is the same regardless of the value of asLocalTime.

localDateTimeLocalDateTime

The local date-time from which to return the number of seconds.

localTimeLocalTime

The local time from which to return the number of seconds.

Returns

The specified date-time converted into seconds. Null input values will return NULL_INT.

Examples