Java Code Examples for java.time.ZonedDateTime#toLocalDateTime()

/**
 * From date time string.
 *
 * @param dateTimeString the date time string
 *
 * @return the local date time using the system time zone
 */
public static LocalDateTime fromDateTimeString(String dateTimeString) {
    LocalDateTime ldt = LocalDateTime.parse(dateTimeString, inputDateTimeFormatter);

    ZonedDateTime ldtZoned;

    if (dateTimeString.endsWith("Z")) {
        ldtZoned = ldt.atZone(ZoneId.of("UTC"));
    } else {
        ldtZoned = ldt.atZone(ZoneId.of("America/New_York"));
    }

    ZonedDateTime localTimeZoned = ldtZoned.withZoneSameInstant(ZoneId.systemDefault());

    return localTimeZoned.toLocalDateTime();
}
 

public static void main(String[] args) {
    var dateTime = ZonedDateTime.now();
    System.out.println("Date Time using now(): " + dateTime);

    var indianTz = ZoneId.of("Asia/Kolkata");
    var istDateTime = ZonedDateTime.now(indianTz);
    System.out.println("Date Time using ZoneId: " + istDateTime);

    var indianTzOffset = ZoneOffset.ofHoursMinutes(5, 30);
    istDateTime = ZonedDateTime.now(indianTzOffset);
    System.out.println("Date Time using ZoneOffset: " + istDateTime);
    
    ZonedDateTime dateTimeOf = ZonedDateTime.of(2018, 4, 22, 14, 30, 11, 33, indianTz);
    System.out.println("Date Time using of(): " + dateTimeOf);

    var localDateTime = dateTimeOf.toLocalDateTime();
    System.out.println("LocalDateTime from ZonedDateTime: " + localDateTime);
    
}
 

/**
 * Binds arguments to prepared statement
 * @param stmt  the prepared statement reference
 * @return      the same as arg
 * @throws SQLException if binding fails
 */
private PreparedStatement bindArgs(PreparedStatement stmt) throws SQLException {
    for (int i=0; i<args.length; ++i) {
        final Object value = args[i];
        if      (value instanceof Boolean)          stmt.setBoolean(i+1, (Boolean)value);
        else if (value instanceof Short)            stmt.setShort(i+1, (Short)value);
        else if (value instanceof Integer)          stmt.setInt(i+1, (Integer)value);
        else if (value instanceof Float)            stmt.setFloat(i+1, (Float)value);
        else if (value instanceof Long)             stmt.setLong(i+1, (Long)value);
        else if (value instanceof Double)           stmt.setDouble(i+1, (Double)value);
        else if (value instanceof String)           stmt.setString(i+1, (String)value);
        else if (value instanceof java.sql.Date)    stmt.setDate(i+1, (java.sql.Date)value);
        else if (value instanceof Timestamp)        stmt.setTimestamp(i+1, (Timestamp)value);
        else if (value instanceof LocalDate)        stmt.setDate(i + 1, java.sql.Date.valueOf((LocalDate)value));
        else if (value instanceof LocalTime)        stmt.setTime(i+1, Time.valueOf((LocalTime)value));
        else if (value instanceof LocalDateTime)    stmt.setTimestamp(i+1, Timestamp.valueOf((LocalDateTime)value));
        else if (value instanceof ZonedDateTime) {
            final ZonedDateTime zonedDateTime = (ZonedDateTime)value;
            final LocalDateTime dateTime = zonedDateTime.toLocalDateTime();
            stmt.setTimestamp(i+1, Timestamp.valueOf(dateTime));
        } else {
            throw new RuntimeException("Unsupported argument, cannot be bound to SQL statement: " + value);
        }
    }
    return stmt;
}
 

@Override
public void wrap(final ZonedDateTime zonedDateTime) {
    this.dateTime = zonedDateTime.toLocalDateTime();
    this.offset = zonedDateTime.getOffset();
    if (zonedDateTime.getZone() != null) {
        this.zoneId = zonedDateTime.getZone().getId();
    }
}
 

DateTimeParserContext(List<DateTimeTokenizer.Token> tokens, Cursor cursor, DateTimeTokenizer tokenizer,
                      ZonedDateTime dateTime) {
    this.tokens = tokens;
    this.cursor = cursor;
    this.tokenizer = tokenizer;
    this.modified = new HashSet<>();
    this.dateTime = dateTime.toLocalDateTime();
    this.zoneId = dateTime.getZone();
}
 

@Override
public LocalDateTime convert(ZonedDateTime source) {
	return source.toLocalDateTime();
}
 

private CommitMetadata newCommitMetadata(String author, Map<String, String> properties){
    ZonedDateTime now = dateProvider.now();
    return new CommitMetadata(author, properties,
            now.toLocalDateTime(), now.toInstant(),
            commitIdFactory.nextId());
}
 

@Override
protected Object[] toConvertedColumns(ZonedDateTime value) {

    return new Object[] { value.toLocalDateTime(), value.getZone() };
}
 

@Nullable
public static LocalDateTime createLocalDateTime (@Nullable final ZonedDateTime aDT)
{
  return aDT == null ? null : aDT.toLocalDateTime ();
}
 

public void testWriteAndReadTemporals() throws Exception {
  ZoneId zoneId = ZoneId.of("America/New_York");
  for (final FileFormat fileFormat : SUPPORTED_FILEFORMATS) {
    Database db = createMem(fileFormat);
    db.setZoneId(zoneId);
    db.setDateTimeType(DateTimeType.LOCAL_DATE_TIME);

    Table table = new TableBuilder("test")
      .addColumn(new ColumnBuilder("name", DataType.TEXT))
      .addColumn(new ColumnBuilder("date", DataType.SHORT_DATE_TIME))
      .toTable(db);

    // since jackcess does not really store millis, shave them off before
    // storing the current date/time
    long curTimeNoMillis = (System.currentTimeMillis() / 1000L);
    curTimeNoMillis *= 1000L;

    DateFormat df = new SimpleDateFormat("yyyyMMdd HH:mm:ss");
    List<Date> tmpDates =
      new ArrayList<Date>(
          Arrays.asList(
              df.parse("19801231 00:00:00"),
              df.parse("19930513 14:43:27"),
              df.parse("20210102 02:37:00"),
              new Date(curTimeNoMillis)));

    List<Object> objs = new ArrayList<Object>();
    List<LocalDateTime> expected = new ArrayList<LocalDateTime>();
    for(Date d : tmpDates) {
      Instant inst = Instant.ofEpochMilli(d.getTime());
      objs.add(inst);
      ZonedDateTime zdt = inst.atZone(zoneId);
      objs.add(zdt);
      LocalDateTime ldt = zdt.toLocalDateTime();
      objs.add(ldt);

      for(int i = 0; i < 3; ++i) {
        expected.add(ldt);
      }
    }

    ((DatabaseImpl)db).getPageChannel().startWrite();
    try {
      for(Object o : objs) {
        table.addRow("row " + o, o);
      }
    } finally {
      ((DatabaseImpl)db).getPageChannel().finishWrite();
    }

    List<LocalDateTime> foundDates = new ArrayList<LocalDateTime>();
    for(Row row : table) {
      foundDates.add(row.getLocalDateTime("date"));
    }

    assertEquals(expected, foundDates);

    db.close();
  }
}
 

@Override
public LocalDateTime convert(ZonedDateTime source) {
	return source.toLocalDateTime();
}
 

public static LocalDateTime date2LocalDateTime(final Date date) {
    Instant instant = date.toInstant();
    ZonedDateTime zdt = instant.atZone(DEFAULT_ZONE_ID);
    return zdt.toLocalDateTime();
}
 

@Override
public LocalDateTime convert(ZonedDateTime source) {
	return source.toLocalDateTime();
}
 

@Override
public LocalDateTime convert(ZonedDateTime source) {
	return source.toLocalDateTime();
}
 

public ZonedDateTimeHandle(ZonedDateTime o) {
    this.dateTime = o.toLocalDateTime();
    this.offset = o.getOffset();
    this.zoneId = o.getZone().getId();
}
 

/**
 * Parses a Date out of a String with a date in W3C date-time format or in a
 * RFC822 format.
 *
 * @param sDate
 *        string to parse for a date.
 * @return the Date represented by the given W3C date-time string. It returns
 *         <b>null</b> if it was not possible to parse the given string into a
 *         Date.
 */
@Nullable
public static LocalDateTime getLocalDateTimeFromW3COrRFC822 (@Nullable final String sDate)
{
  final ZonedDateTime aDateTime = getDateTimeFromW3COrRFC822 (sDate);
  return aDateTime == null ? null : aDateTime.toLocalDateTime ();
}
 

/**
 * Merge a LocalTime and a LocalDate to a LocalDateTime in UTC time zone
 *
 * @param millisecond
 * @param nanosecond
 * @return LocalDateTime (UTC)
 */
public static LocalDateTime toLocalDateTime(LocalDate date, LocalTime time) {
    ZonedDateTime zonedDateTime = toZonedDateTime(date, time);
    return zonedDateTime.toLocalDateTime();
}
 

/**
 * Convert TemporalAccessor to LocalDateTime
 * 
 * @param temporal
 * @return LocalDateTime (UTC)
 */
public static LocalDateTime toLocalDateTime(TemporalAccessor temporal) {
    ZonedDateTime zonedDateTime = toZonedDateTime(temporal);
    return zonedDateTime.toLocalDateTime();
}
 

/**
 * 根据指定日期时间获取下一次日期时间
 * 
 * @param dateTime
 * @return
 */
public LocalDateTime getNextDateTime(LocalDateTime dateTime) {
    ZonedDateTime instant = getNextDateTime(ZonedDateTime.of(dateTime, ZoneOffset.UTC));
    return instant == null ? null : instant.toLocalDateTime();
}
 

/**
 * 根据指定日期时间获取上一次日期时间
 * 
 * @param dateTime
 * @return
 */
public LocalDateTime getPreviousDateTime(LocalDateTime dateTime) {
    ZonedDateTime instant = getPreviousDateTime(ZonedDateTime.of(dateTime, ZoneOffset.UTC));
    return instant == null ? null : instant.toLocalDateTime();
}