topic Re: Filtering based on Time Stamp. in Application Development and Automation Discussions

Filtering based on Time Stamp.

Former Member — Tue, 16 Oct 2007 15:24:28 GMT

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.

Re: Filtering based on Time Stamp.

Former Member — Tue, 16 Oct 2007 15:27:18 GMT

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.

Re: Filtering based on Time Stamp.

Former Member — Tue, 16 Oct 2007 15:27:25 GMT

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

Re: Filtering based on Time Stamp.

Former Member — Tue, 16 Oct 2007 15:30:07 GMT

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