Timestamp field selection using date field

[vikash_pathak]

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

[vikash_pathak]

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

[vijay_hariharan]

Check the below thread:

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

[vikash_pathak]

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

[vijay_hariharan]

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

[vikash_pathak]

It was helpful .

Thanks

[RaymondGiuseppi]

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>

[Sandra_Rossi]

fyi typo in code (235859)

[Sandra_Rossi]

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.