Skip to Content
0
Former Member
Feb 26, 2009 at 03:21 PM

SELECT on TIMESTAMP field from ABAP with EXEC SQL

2978 Views

Hello,

I'm trying to get a field of one table which is defined as TIMESTAMP. MaxDB parameter DATE_TIME_FORMAT is set to INTERNAL. When I do the SELECT in SQL Studio I get ISO format 'YYYY-MM-DD HH:MM:SS.MMMMMM' back. So I tried a SELECT with ISO in WHERE clause, but I'm always getting a shortdump with this error:

Database error text........: "POS(82) Invalid date input value"

Database error code........: "-3065"

Then I did a SELECT without a WHERE clause in ABAP and got value '06-FEB-09' back from this field. So I tried with this ABAP statement and got no shortdump, but I also need to add time and not only the date.

EXEC SQL.

SELECT recv_time INTO :l_time FROM ztest WHERE sent_recv_time = '06-FEB-09'

ENDEXEC.

I'm using Native SQL because the SELECT is on a table which is not located in SAP Schema User. "SELECT recv_time FROM ztest WHERE recv_time = '2009-02-24 10:02:55.888000'" works in SQL studio, but not from ABAP.

Does anyone know which format I need to specify in the WHERE clause?

Regards

Markus Karsch

Edited by: Markus Karsch on Feb 26, 2009 4:22 PM