topic Re: Native Sql-- Date problem in Application Development and Automation Discussions

Native Sql-- Date problem

Former Member — Fri, 05 Feb 2010 16:54:18 GMT

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 — Fri, 05 Feb 2010 16:58:43 GMT

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 — Fri, 05 Feb 2010 18:20:13 GMT

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 — Fri, 05 Feb 2010 18:21:09 GMT

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