How to correct the error Syntax of date, time, or timestamp value not valid

[Former Member]

Hi All,

I am using JDBC adaptor. Its giveing the error as 'Syntax of date, time, or timestamp value not valid' when testing the interface. Pl help out to solve this issue.I am new to XI.

Regards,

Ramalakshmi.G

[Former Member]

Hi,

Check you date and time format in XI system how they maintain. For that login to R/3 and in the top you will see system->User profile->own data-> there you will see 3 tabs click on Default tab and you can see date and time format there. Check that and accordingly give your date format settings in Graphical mapping

Hope this will help you.

Thanks

Vikranth

[Former Member]

Hi Ramalakshmi,

Refer the following blog

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

or use the following UDF - Input Date

-

---

if(Date!="")

{

return "TO_DATE('"Date"','DDMMYYYY')";

}

else

return Date;

-

---

Replace the Date Format with whatever format you are using.

Donot forget to specify attribute hasQuot = No for the target date field, while creating data type.

Edited by: Shamly MM on Jun 26, 2008 11:07 AM

[Former Member]

Use the correct format

[Former Member]

Hi,

Try to find out the date format of your database. and check the same with your data. else transform the input data as required for the database.

Thanks,

Indira D