How to get data using Timestamp

[Former Member]

Hi gurus ,

I am inserting the data in one table

in that onefield is timestamp.

in that i am concatenating sy-datum and sy-uzeit.

now i have to fetch the data using date .

How can i ..fetch the data..?

can anyone suggest me..?

i tried date*, and %date% also

still its not fetching the data..

Thanks & Regards

kalyan.

[Former Member]

Also concatenate the the miimum time and maximum time to the date and select.

Hope you got the idea.

[agnihotro_sinha2]

Did you try Logical operators: CA (contains ANy) or similar things?

[kesavadas_thekkillath]

Also concatenate the the miimum time and maximum time to the date and select.

Hope you got the idea.

[former_member206439]

Hi Kalyan,

Try useing below condition once.

In where condition directly put

Where

TIMESTAMP EQ SY-DATUM

SY-DATUM or you own date.

I tries the same and its working fine.

Thanks

Naresh

[RaymondGiuseppi]

Use a range, fill it with range-low = date + '00:00:00', range-high = date + '23:59:59', and use a timestamp IN range in the WHERE option of the SELECT statement. (or a BETWEEN)

Regards,

Raymond

[Former Member]

How do you select records from a table when the field on the tableis defined as timestamp and the select-options field is defined as sy-datum?

[Former Member]

I'm also sorting this out. I think you need to use the command

 convert date sy-datum time sy-uzeit time into time stamp 'your field' time zone 'UTC' 

to make a field that is like the time stamp you want to select.

But I haven't been able to get any data as well so far.

[Former Member]

Hi,

* Declaring the work variables.......................
DATA :
  timestamp like TZONREF-TSTAMPS,
  time      like sy-uzeit,
  date      like sy-datum.

* The following function module is used to convert the
* time and date into GMT timestamp

CALL FUNCTION 'IB_CONVERT_INTO_TIMESTAMP'
  EXPORTING
    i_datlo           = sy-datum
    i_timlo           = sy-uzeit
    I_TZONE           = 'INDIA'
 IMPORTING
   E_TIMESTAMP       = timestamp.

* The following function module is used to convert the
* above obtained timestamp to PST time zone date and time.

CALL FUNCTION 'IB_CONVERT_FROM_TIMESTAMP'
  EXPORTING
    i_timestamp       = timestamp
    I_TZONE           = 'PST'
 IMPORTING
    E_DATLO           = date
    E_TIMLO           = time.

write :/ 'Date and Time at PST zone is ',date, time.