Database Query

[Former Member]

Hi All,

In my database table 1 field of

Format (contract end date): DDMMYYYY HHMMSS

While writing the Query in the where clause i can't pass the value for the HHMMSS (Hour minute second) , i can only pass the MMYYYY (month year). So in this case How to write a query to get the data based on my date.

Sunil

[Former Member]

Hi Sunil,

Concatenate date field and time field into variable of type that you specify in ur table and pass the variable in ur where clause.

Yogesh N

[Former Member]

Hi!

Try to address the time data this way:

datum_time+9(6)

Regards

Tamá

[Former Member]

Hope u didn't understand my Q.

Clarify Below:

SELECT HEADER date_4 from crmd_order_index into table i_guid where stat_released = 'X'

AND date_2 = l_date.

D/B Field: date_2--> Format---> DDMMYYYY HHMMSS

Prog. Field: l_date-> Format---> DDMMYYYY

Sunil

[Former Member]

Hi Sunil,

Concatenate date field and time field into variable of type that you specify in ur table and pass the variable in ur where clause.

Yogesh N

[Former Member]

Hi

Then in such caes u write query like this.

select * from <table>
   into  ...
 where timefiled like '%YYYYMM%'.

...

endselect.

Regards,

Sunil Kumar Mutyala

[Former Member]

Hi,

Write this way-

Data: w_date type sy-datum,
         w_pass(10) type c.

w_date = date+2(6).

concatenate '%' w_date '%' into w_pass.

Select * from ztable into itab where date like w_pass.

Regards,

Sujit