Native Sql-- Date problem

[Former Member]

Hi experts,

i want to get some bills from external database. i try above method and im getting dump.

how can i solve this problem

PARAMETERS :

p_xdate TYPE zpcishkd_timestamp DEFAULT '06/01/2010 10:36:53'.

EXEC SQL PERFORMING loop_output.

SELECT

LNGKOD,

TXTKOD

INTO :ls_dist-LNGKOD,

:ls_dist-TXTKOD

FROM TBLDIST

WHERE TRHSONISLEMTARIHI >=

:p_xdate

ENDEXEC.

[Former Member]

Well, you have to format the timestamp so that it is in the same format required by the database you are using. What database is that?

Also, what is the dump that you are getting?

Rob

[Former Member]

Thnaks for reply..

i solved the problem myself.

i saw the data difference at mssql. i sent datetime like i get datetime from sqlSql. It is true format and working.

it looks like 03/02/2009 but when i select it returns 2009-02-03

Thankss

[Former Member]

True format is 2009-06-22 02:02:02