oracle sql: < /p>
select trunc( sysdate, 'Month') month
from dual
< /code>
java: < /p>
java.sql.Date sqlDate = resultSet.getDate("month");
log.info(sqlDate);
DateTime dateTime = new DateTime(sqlDate.getTime());
log.info(dateTime);
dateTime = dateTime.withMillisOfDay(0);
log.info(dateTime);
< /code>
Вывод: < /p>
2012-01-01 < /p>
2012-01-01t 01 < /strong>: 00: 00.000+07: 00 < /p>
Подробнее здесь: https://stackoverflow.com/questions/884 ... conversion