Package oracle.sql

Examples of oracle.sql.TIMESTAMP

806
807
808
809
810
811
812
813
814
815
816
817
  public static String convertDate(Object date) {
    String result = null;
    if (date!=null) {
      if (date instanceof TIMESTAMP){
        try {
           TIMESTAMP ts = (TIMESTAMP)date;
           Date dateTemp =   new Date(ts.timestampValue().getTime());
           result = dfyyyyMMddHHMMSS.format(dateTemp);
            
        } catch (SQLException e) {
          e.printStackTrace();
        }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
  public Object toObjectByType(String input, Class javaType) {

    if (javaType == TIMESTAMP.class) {
      long time = DateUtil.parse(input).getTime();
      Timestamp stamp = new Timestamp(time);
      return new TIMESTAMP(stamp);
    }
    if (javaType == oracle.sql.CLOB.class || javaType == oracle.sql.BLOB.class) {
      InputStream is = getStream(input);
      return is;
    }
View Full Code Here
98
99
100
101
102
103
104
105
106
107
108
  @Override
  protected Object getDefaultValue(Class javaType) {
    if (javaType == TIMESTAMP.class) {
      java.util.Date now = new java.util.Date();
      Timestamp stamp = new Timestamp(now.getTime());
      return new TIMESTAMP(stamp);
    }
    if (javaType == oracle.sql.CLOB.class || javaType == oracle.sql.BLOB.class) {
      InputStream is = getStream("stream");
      return is;
    }
View Full Code Here
31
32
33
34
35
36
37
38
39
        new OracleTimestampNormaliser().normalise("Any Old Object");
    }

    @Test
    public void shouldReturnContentsOfClobIFAllOkay() throws SQLException {
        TIMESTAMP ts = mock(TIMESTAMP.class);
        when(ts.timestampValue()).thenReturn(new Timestamp(0l));
        assertEquals(new Timestamp(0l), new OracleTimestampNormaliser().normalise(ts));
    }
View Full Code Here
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
    public void testDateConversion( ) throws ConverterException {

        // assert java.sql.Date.
        long millis = LocalDate.now().toDateTimeAtStartOfDay().getMillis();
        java.sql.Date sqlDate = new java.sql.Date( millis );
        TIMESTAMP oracleTimestamp = new TIMESTAMP(sqlDate);
        Date convertedDate = Convert.getConverterIfExists(Date.class).convert(oracleTimestamp);

        assertEquals(sqlDate, convertedDate);

        // assert java.util.Date
        Date origDate = new Date();
        oracleTimestamp = new TIMESTAMP(new Timestamp(origDate.getTime()));
        convertedDate = Convert.getConverterIfExists(Date.class).convert(oracleTimestamp);

        assertEquals(origDate, convertedDate);
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46

    @Test
    public void testDateTimeConverter() throws ConverterException {
        DateTime d = DateTime.now();
        TIMESTAMP oracleTimestamp = new TIMESTAMP(new Timestamp(d.getMillis()));
        DateTime convertedDateTime = Convert.getConverterIfExists(DateTime.class).convert(oracleTimestamp);

        assertEquals(d, convertedDateTime);
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
    }

    @Test
    public void testLocalTimeConverter() throws ConverterException {
        LocalTime lt = LocalTime.now();
        oracle.sql.TIMESTAMP oracleTime = new TIMESTAMP(new Timestamp(lt.toDateTimeToday().getMillis()));
        LocalTime convertedTime = Convert.getConverterIfExists(LocalTime.class).convert(oracleTime);

        assertEquals(lt, convertedTime);
    }
View Full Code Here
TOP

Related Classes of oracle.sql.TIMESTAMP

  • com.founder.fix.fixflow.core.impl.util.DateUtil
  • dbfit.environment.OracleTimestampNormaliserTest
  • org.jtester.module.database.environment.typesmap.OracleTypeMap
  • org.sql2o.converters.OracleConverterTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.