• Home
• com.github.marschall
• threeten-jpa-test
• 1.12
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

rschall.threeten-jpa-test.1.12.source-code.sqlserver-data.sql Maven / Gradle / Ivy

DELETE FROM JAVA_TIME_42;
INSERT INTO JAVA_TIME_42 (
    ID,
    DATE_COLUMN,
    TIME_COLUMN,
    TIMESTAMP_COLUMN)
VALUES(
    1,
    '1988-12-25',
    '15:09:02.123456',
    '1980-01-01 23:03:20.123456');
INSERT INTO JAVA_TIME_42 (
    ID,
    DATE_COLUMN,
    TIME_COLUMN,
    TIMESTAMP_COLUMN)
VALUES(
    2,
    '2016-03-27',
    '02:55:00.1234567',
    '2016-03-27 02:55:00.123456');

DELETE FROM JAVA_TIME_42_WITH_ZONE;
INSERT INTO JAVA_TIME_42_WITH_ZONE (
    ID,
    OFFSET_DATE_TIME_COLUMN)
VALUES(
    1,
    '1960-01-01 23:03:20.123456+02:30');
INSERT INTO JAVA_TIME_42_WITH_ZONE (
    ID,
    OFFSET_DATE_TIME_COLUMN)
VALUES(
    2,
    '1999-01-23 08:26:56.123456-05:30');

DELETE FROM JAVA_TIME_42_ZONED;
INSERT INTO JAVA_TIME_42_ZONED (
    ID,
    TIMESTAMP_UTC,
    ZONE_ID)
VALUES(
    1,
    '1999-01-23 08:26:56.123456Z',
   'America/New_York');