} else if (type == Date.class || type == java.sql.Date.class || type == java.sql.Timestamp.class || type == java.sql.Time.class) { try { Date date = new SimpleDateFormat(DATE_FORMAT).parse((String) value); if (type == java.sql.Date.class) { return new java.sql.Date(date.getTime()); } else if (type == java.sql.Timestamp.class) { return new java.sql.Timestamp(date.getTime()); } else if (type == java.sql.Time.class) { return new java.sql.Time(date.getTime()); } else { return date;
/** * Add or subtract the specified number of days from DATE */ public Var changeDateByInt(Date d, Long i, boolean add) { Calendar c = Calendar.getInstance(); c.setTimeInMillis(d.getTime()); int days = i.intValue(); if(!add) { days *= -1; } c.add(Calendar.DAY_OF_MONTH, days); return new Var(new Date(c.getTimeInMillis())); }
return new Date(((Calendar)value).getTimeInMillis()); return new Date(((java.util.Date)value).getTime()); return new Date(((Number) value).longValue()); return Date.valueOf(stringValue); } catch (IllegalArgumentException iaex) { throw new TypeConversionException(value, iaex); return new Date(milliseconds); } catch (NumberFormatException nfex) { throw new TypeConversionException(value, nfex);
public String objectToSQLString(Date value, Dialect dialect) throws Exception { final java.sql.Date jdbcDate = java.sql.Date.class.isInstance( value ) ? ( java.sql.Date ) value : new java.sql.Date( value.getTime() ); // TODO : use JDBC date literal escape syntax? -> {d 'date-string'} in yyyy-mm-dd format return StringType.INSTANCE.objectToSQLString( jdbcDate.toString(), dialect ); }
@SuppressWarnings({ "unchecked" }) public <X> X unwrap(Calendar value, Class<X> type, WrapperOptions options) { if ( value == null ) { return null; } if ( Calendar.class.isAssignableFrom( type ) ) { return (X) value; } if ( java.sql.Date.class.isAssignableFrom( type ) ) { return (X) new java.sql.Date( value.getTimeInMillis() ); } if ( java.sql.Time.class.isAssignableFrom( type ) ) { return (X) new java.sql.Time( value.getTimeInMillis() ); } if ( java.sql.Timestamp.class.isAssignableFrom( type ) ) { return (X) new java.sql.Timestamp( value.getTimeInMillis() ); } if ( java.util.Date.class.isAssignableFrom( type ) ) { return (X) new java.util.Date( value.getTimeInMillis() ); } throw unknownUnwrap( type ); }
System.out.println( new SimpleDateFormat("yyyy/MM/dd HH:mm:ss").format(Calendar.getInstance().getTime()) ); System.out.println( new SimpleDateFormat("HH:mm:ss").format(Calendar.getInstance().getTime()) ); System.out.println(new SimpleDateFormat("MM/dd/yyyy").format(Calendar.getInstance().getTime())); System.out.println( new Date(System.currentTimeMillis()) ); System.out.println( new Date().toString().substring(0, 10) ); System.out.println( new java.sql.Date(System.currentTimeMillis()) ); Date d = new Date(); System.out.println( (d.getTime() / 1000 / 60 / 60) % 24 + ":" + (d.getTime() / 1000 / 60) % 60 + ":" + (d.getTime() / 1000) % 60 ); System.out.println( new Timestamp(System.currentTimeMillis()) );
java.util.Calendar cal = Calendar.getInstance(); java.util.Date utilDate = new java.util.Date(); // your util date cal.setTime(utilDate); cal.set(Calendar.HOUR_OF_DAY, 0); cal.set(Calendar.MINUTE, 0); cal.set(Calendar.SECOND, 0); cal.set(Calendar.MILLISECOND, 0); java.sql.Date sqlDate = new java.sql.Date(cal.getTime().getTime()); // your sql date System.out.println("utilDate:" + utilDate); System.out.println("sqlDate:" + sqlDate);
/** * Parse the string of data into {@code java.sql.Date} object * with specified pattern * * @param date the input data string * @param pattern the given pattern * @return {@code java.sql.Date} object * @throws Exception if error occurs */ public static java.sql.Date parse(String date, String pattern) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat(pattern); return new java.sql.Date(sdf.parse(date).getTime()); }
public class MainClass { public static void main(String[] args) { java.util.Date utilDate = new java.util.Date(); java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime()); System.out.println("utilDate:" + utilDate); System.out.println("sqlDate:" + sqlDate); } }
java.util.Date myDate = new java.util.Date("10/10/2009"); java.sql.Date sqlDate = new java.sql.Date(myDate.getTime()); sb.append("INSERT INTO USERS"); sb.append("(USER_ID, FIRST_NAME, LAST_NAME, SEX, DATE) "); sb.append("VALUES ( "); sb.append("?, ?, ?, ?, ?"); sb.append(")"); Connection conn = ...;// you'll have to get this connection somehow PreparedStatement stmt = conn.prepareStatement(sb.toString()); stmt.setString(1, userId); stmt.setString(2, myUser.GetFirstName()); stmt.setString(3, myUser.GetLastName()); stmt.setString(4, myUser.GetSex()); stmt.setDate(5, sqlDate); stmt.executeUpdate(); // optionally check the return value of this call
ps.setString(paramIndex, inValue.toString()); ps.setNString(paramIndex, inValue.toString()); ps.setNClob(paramIndex, new StringReader(strVal), strVal.length()); ps.setDate(paramIndex, new java.sql.Date(((java.util.Date) inValue).getTime())); ps.setDate(paramIndex, new java.sql.Date(cal.getTime().getTime()), cal); ps.setTime(paramIndex, new java.sql.Time(((java.util.Date) inValue).getTime())); ps.setTime(paramIndex, new java.sql.Time(cal.getTime().getTime()), cal); ps.setTimestamp(paramIndex, new java.sql.Timestamp(((java.util.Date) inValue).getTime())); ps.setTimestamp(paramIndex, new java.sql.Timestamp(cal.getTime().getTime()), cal); "Oracle".equals(ps.getConnection().getMetaData().getDatabaseProductName()))) { if (isStringValue(inValue.getClass())) { ps.setString(paramIndex, inValue.toString()); ps.setTimestamp(paramIndex, new java.sql.Timestamp(((java.util.Date) inValue).getTime()));
final SimpleDateFormat dateFormat = new SimpleDateFormat(format); dateFormat.setTimeZone(TimeZone.getTimeZone("UTC")); return dateFormat.parse(dateStr).getTime(); } catch (ParseException e) { throw new RuntimeException(e); final java.sql.Date date = new java.sql.Date(toMillis.apply("yyyy/MM/dd", "2017/05/10")); when(rs.getObject(1)).thenReturn(date); final Time time = new Time(toMillis.apply("HH:mm:ss.SSS", "12:34:56.789")); when(rs.getObject(2)).thenReturn(time); final Timestamp timestamp = new Timestamp(toMillis.apply("yyyy/MM/dd HH:mm:ss.SSS", "2017/05/11 19:59:39.123")); when(rs.getObject(3)).thenReturn(timestamp);
@Test public void testUnfoundMultiColumnCaseStatement() throws Exception { String query = "SELECT entity_id, b_string FROM ATABLE WHERE organization_id=? and CASE WHEN a_integer = 1234 THEN 1 WHEN a_date < ? THEN y_integer WHEN x_integer = 4 THEN 4 ELSE 3 END = 4"; String url = PHOENIX_JDBC_URL + ";" + PhoenixRuntime.CURRENT_SCN_ATTRIB + "=" + (ts + 5); // Run query at timestamp 5 Properties props = new Properties(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(url, props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); statement.setDate(2, new Date(System.currentTimeMillis())); ResultSet rs = statement.executeQuery(); assertTrue(rs.next()); assertEquals(ROW8, rs.getString(1)); assertFalse(rs.next()); } finally { conn.close(); } }
try (PreparedStatement statement = conn.prepareStatement(queryLine.getResultQuery())) { this.statement = statement; int n = 1; statement.setObject(n, obj); } else if (!parameter.isArray() && parameter.isObject()) { statement.setObject(n, getValue(obj, parameter.getFieldName())); } else if (parameter.isArray()) { int index; statement.setObject(n, ((List) obj).get(index)); } else if (obj.getClass().isArray()) { Object arrayElement = Array.get(obj, index); if (java.sql.Date.class.getName().equals(rs.getMetaData().getColumnClassName(i))) { java.sql.Date sqlDate = rs.getDate(i); row.add(sqlDate == null ? null : new Date(sqlDate.getTime())); } else { row.add(rs.getObject(i)); conn.rollback(); } catch (Exception e1) {
package com.sandbox; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; public class Sandbox { public static void main(String[] args) throws ParseException { SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd"); Date parsed = format.parse("20110210"); java.sql.Date sql = new java.sql.Date(parsed.getTime()); } }
@Override public java.sql.Date deserialize(JsonParser p, DeserializationContext ctxt) throws IOException { Date d = _parseDate(p, ctxt); return (d == null) ? null : new java.sql.Date(d.getTime()); } }
@Test public void testDateType() { final long now = System.currentTimeMillis(); final java.sql.Date original = new java.sql.Date( now ); final java.sql.Date copy = new java.sql.Date( now ); Calendar cal = new GregorianCalendar(); cal.clear(); cal.setTimeInMillis( now ); cal.add( Calendar.YEAR, 1 ); final java.sql.Date different = new java.sql.Date( cal.getTime().getTime() ); runBasicTests( DateType.INSTANCE, original, copy, different ); }
@Test public void testConvertDate() throws SQLException { LocalDate date = LocalDate.of(2001, 5, 6); Date sqlDate = Date.valueOf(date); java.util.Date javaDate = new java.util.Date(sqlDate.getTime()); LocalDateTime dateTime = LocalDateTime.of(date, LocalTime.of(12, 34, 56)); Timestamp sqlTimestamp = Timestamp.valueOf(dateTime); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setDate(i, sqlDate)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, sqlDate)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, sqlDate, Types.DATE)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, sqlTimestamp, Types.DATE)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, javaDate, Types.DATE)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, date, Types.DATE)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, dateTime, Types.DATE)); assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, "2001-05-06", Types.DATE)); }