topic Re: How to get data using Timestamp in Application Development and Automation Discussions

How to get data using Timestamp

Former Member — Wed, 05 May 2010 13:00:49 GMT

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.

Re: How to get data using Timestamp

agnihotro_sinha2 — Wed, 05 May 2010 13:06:02 GMT

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

Re: How to get data using Timestamp

kesavadas_thekkillath — Wed, 05 May 2010 13:22:53 GMT

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

Hope you got the idea.

Re: How to get data using Timestamp

former_member206439 — Wed, 05 May 2010 13:27:11 GMT

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

Re: How to get data using Timestamp

RaymondGiuseppi — Wed, 05 May 2010 14:01:12 GMT

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

Re: How to get data using Timestamp

Former Member — Wed, 12 May 2010 11:46:47 GMT

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?

Re: How to get data using Timestamp

Former Member — Fri, 28 May 2010 14:40:38 GMT

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.

Re: How to get data using Timestamp

former_member233090 — Fri, 28 May 2010 15:28:59 GMT

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.