Teiid - teradata:
Date
getObject(int): 1999-12-31
getDate(int): 1999-12-31
getDate(int,Calendar) - default TimeZone: 1999-12-31
getDate(int,Calendar) - GMT+5:00: 1999-12-30
Time
getObject(int): 23:00:00
getTime(int): 23:00:00
getTime(int,Calendar) - default TimeZone: 23:00:00
getTime(int,Calendar) - GMT+5:00: 19:00:00
Timestamp
getObject(int): 1999-12-31 23:00:00.0
getTimestamp(int): 1999-12-31 23:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 1999-12-31 23:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 19:00:00.0
-----------------------------------------------------
Teradata:
Date
getObject(int): 2000-01-01
getDate(int): 2000-01-01
getDate(int,Calendar) - default TimeZone: 1999-12-31
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 00:00:00
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 23:00:00
getTime(int,Calendar) - GMT+5:00: 19:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 1999-12-31 23:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 19:00:00.0
-----------------------------------------------------
Teiid - mysql55:
Date
getObject(int): 2000-01-01
getDate(int): 2000-01-01
getDate(int,Calendar) - default TimeZone: 2000-01-01
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 00:00:00
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 00:00:00
getTime(int,Calendar) - GMT+5:00: 20:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 20:00:00.0
-----------------------------------------------------
Mysql55:
Date
getObject(int): 2000-01-01
getDate(int): 2000-01-01
getDate(int,Calendar) - default TimeZone: 2000-01-01
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 00:00:00
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 00:00:00
getTime(int,Calendar) - GMT+5:00: 00:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 2000-01-01 00:00:00.0
-----------------------------------------------------
Teiid - postgresql92:
Date
getObject(int): 2000-01-01
getDate(int): 2000-01-01
getDate(int,Calendar) - default TimeZone: 2000-01-01
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 00:00:00
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 00:00:00
getTime(int,Calendar) - GMT+5:00: 20:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 20:00:00.0
-----------------------------------------------------
Postgresql92:
Date
getObject(int): 2000-01-01
getDate(int): 2000-01-01
getDate(int,Calendar) - default TimeZone: 2000-01-01
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 00:00:00
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 00:00:00
getTime(int,Calendar) - GMT+5:00: 20:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 20:00:00.0
-----------------------------------------------------
Teiid - oracle12:
Date
getObject(int): 2000-01-01
getDate(int): 2000-01-01
getDate(int,Calendar) - default TimeZone: 2000-01-01
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 00:00:00
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 00:00:00
getTime(int,Calendar) - GMT+5:00: 20:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 20:00:00.0
-----------------------------------------------------
Oracle12:
Date
getObject(int): 2000-01-01 00:00:00.0
getDate(int): 2000-01-01 00:00:00.0
getDate(int,Calendar) - default TimeZone: 2000-01-01
getDate(int,Calendar) - GMT+5:00: 1999-12-31
Time
getObject(int): 1970-01-01 00:00:00.0
getTime(int): 00:00:00
getTime(int,Calendar) - default TimeZone: 00:00:00
getTime(int,Calendar) - GMT+5:00: 20:00:00
Timestamp
getObject(int): 2000-01-01 00:00:00.0
getTimestamp(int): 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - default TimeZone: 2000-01-01 00:00:00.0
getTimestamp(int,Calendar) - GMT+5:00: 1999-12-31 20:00:00.0
-----------------------------------------------------