topic Re: Timestamp field selection using date field in Application Development and Automation Discussions

Timestamp field selection using date field

vikash_pathak — Thu, 25 Nov 2021 05:03:33 GMT

Hi All,

I am fetching data from VLCHISTORY table ,

in which data has to be selected for todays date , for that TSTMP field has to be used,

and on ABAP report selection screen i have parameter field type of DATUM.

how datum field can be used with TSTMP field for data retrieval.

Please share the solution.

Thanks

Vikash

Re: Timestamp field selection using date field

vijay_hariharan — Thu, 25 Nov 2021 05:29:13 GMT

Check the below thread:

https://answers.sap.com/questions/13524415/timestamp-in-db-table-compare-with-select-options.html

Re: Timestamp field selection using date field

vikash_pathak — Thu, 25 Nov 2021 05:49:31 GMT

Hi,

In this thread , at first data is being selected from DB table and then data is being deleted from internal table,

i have to filter data while selecting it from DB table itself. otherwise it will return all the record .

Thanks

Re: Timestamp field selection using date field

vijay_hariharan — Thu, 25 Nov 2021 05:54:58 GMT

Please check the second answer thread in the link:
https://answers.sap.com/questions/8079633/select-query-on-time-stamp.html

Re: Timestamp field selection using date field

RaymondGiuseppi — Thu, 25 Nov 2021 11:59:33 GMT

Just convert the date into two timestamps (at 00:00:00 and 23:59:59) select with database timestamp field between those values?

CONVERT DATE p_date  TIME '000000'
   INTO TIME STAMP low_timestamp
   TIME ZONE sy-zonlo.

CONVERT DATE p_date  TIME '235959'
   INTO TIME STAMP high_timestamp
   TIME ZONE sy-zonlo.

SELECT COUNT(*) FROM vlchistory
   WHERE tstmp BETWEEN low_timestamp AND high_timestamp.<br>

Re: Timestamp field selection using date field

Sandra_Rossi — Thu, 25 Nov 2021 15:18:35 GMT

You need to make sure of the time zone of values in VLCHISTORY-TSTMP. Usually it's UTC.

Usually, people will enter the date for their local time zone, so you should convert from user's time zone to VLCHISTORY-TSTMP time zone.

See Raymond answer for more details.

Re: Timestamp field selection using date field

vikash_pathak — Fri, 26 Nov 2021 04:59:42 GMT

It was helpful .

Thanks

Re: Timestamp field selection using date field

Sandra_Rossi — Fri, 26 Nov 2021 06:52:55 GMT

fyi typo in code (235859)