Skip to Content
-2

ABAP- Read data that have been created today

Dear All,

I have a question regarding to ABAP where statement. in my table I have a field that is CreatedTimestamp of record, But I need to read the data that are created today(Based on system time obviously)

My requirement is to

Select * from Ztable where (CreatedTimestamp is today)

Any help will be appreciate.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 09 at 03:10 PM

    Hi,

    You could generate two timestamps, one representing 12:00AM TODAY and another representing 11:59PM TODAY, then write your query as...

    SELECT * 
           FROM Ztable 
           WHERE CreatedTimestamp BETWEEN low_timestamp AND high_timestamp.

    Cheers,

    Amy

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 06 at 10:02 AM
    Add comment
    10|10000 characters needed characters exceeded