Filtering based on Time Stamp.

[Former Member]

Hi All,

I have a DB Table that stores the created date and created time are being stored in a single field of type TIMESTAMP.

My requirement is: I have a report with a selection screen where the user enters the create date in a select-option and i have to fetch the records from this DB Table which are created in the date(s) entered in the select-option.

How can i write a SELECT Query for this.

Thanks & Regards,

Goutham.

[Former Member]

Hi Raghavendra,

Write the select query as follows:

Select fieldname from DB table nto internal table where timestamp in date.

where date is the date entered in the select optons on the selection screen.

In case you have any further clarifications,do let me know.

Regards,

Puneet Jhari.

[Former Member]

Hi Raghavendra,

Write the select query as follows:

Select fieldname from DB table nto internal table where timestamp in date.

where date is the date entered in the select optons on the selection screen.

In case you have any further clarifications,do let me know.

Regards,

Puneet Jhari.

[Former Member]

HI,

You can convert the time stamp to DAte and time then use the date in the select statment.

CONVERT TIME STAMP tst TIME ZONE tz INTO DATE d TIME t.

Look at the below link for more info

http://www.s001.org/ABAP-Hlp/abapconvert_time-stamp.htm

Regards

Sudheer

[Former Member]

Hi Goutham,

Using DATE entered on selection screen, populate another RANGES (which is declared as DATETIMESTAMP).

Pass this RANGES to your SELECT and extract data.

Hope this helps.

ashish