SQL DATA TYPE FOR DATE

former_member698032 — Wed, 02 Sep 2020 14:39:25 GMT

Dear All,

I am creating a column table using SQL

CREATE COLUMN TABLE "EMPLOYEE_MAY"(DNUMBER INT, NAME VARCHAR(10), DOB DATE, REMINDERDAYS INT, DEPID INT);

INSERT INTO "EMPLOYEE_MAY" VALUES ('102025', 'RAMESH', '1978-03-23', '33', '10');

However while executing the same I am getting below error. The data type for DOB is taken as DATE & also the date format is taken as YYYY-MM-DD format. I have check the threads for the same and have taken the correct format but still I am getting below error.

Could not execute 'INSERT INTO "EMPLOYEE_MAY" VALUES ('102025', 'RAMESH', '1978-03-23', '33', '10')' SAP DBTech JDBC: [339]: invalid number: not a valid number string '1978-03-23' at function __typecast__() (at pos 55)

Can you please support for the same.

Thanks In Advance

Re: SQL DATA TYPE FOR DATE

Yogananda — Wed, 02 Sep 2020 15:35:59 GMT

Hi bande_ramesh91

Try this , It will work

INSERT INTO "EMPLOYEE_MAY" VALUES ('102025', 'RAMESH', TO_DATE('1978-03-23', 'YYYY-MM-DD'), '33', '10');

Re: SQL DATA TYPE FOR DATE

former_member698032 — Thu, 03 Sep 2020 12:41:18 GMT

THANKS A LOT

topic SQL DATA TYPE FOR DATE in Application Development and Automation Discussions

SQL DATA TYPE FOR DATE

Re: SQL DATA TYPE FOR DATE

Re: SQL DATA TYPE FOR DATE