timestamp issue in JDBC sender adapter

[Former Member]

All,

Database is sending the timestamp in th below format,

28-06-2010 12:41:20

but SAP PI JDBC adapter is converting the same data as below.

28-06-2010 12:41:20.0

we are getting an extra ZERO, can any one tell me the solution for not getting extra ZERO.

Thank You,

Madhav

[Former Member · Accepted solution]

Try to Use JDBC Date Function in Select Query .

to_char( Coloumn_name , 'DD-MON-YYYY HH:MI:SS')

it will forcefully get the date in following format .. but one thing to remeber this will covert your date into string format ..so to catch the following date on sender Message Type , it may require to create that structure with string type.

Regards

Prabhat Sharma(Dragon).

[Former Member]

or if you want to remove hours minutes and second , try using trunc function in select query

eg : trunc(column_date)

select trunc(column_date) from dual.

[Former Member]

hi all,

any other suggestions ??

Thank You,

Madhav

[Former Member]

Use Date transformation function in Mapping.

ddmmyyyy hh:mm:ss

Regards

Ramg