topic Re: Current date for a time zone in Application Development and Automation Discussions

Current date for a time zone

Former Member — Wed, 17 May 2006 19:51:51 GMT

Dear All,

Is there any function module to find the current date for a given time zone?

If anyone of you has written/worked on such function module it would be really helpful.

Thanks,

Amit

Re: Current date for a time zone

Former Member — Wed, 17 May 2006 19:55:53 GMT

Check these FMs

TZON_CHECK_TIMEZONE

TZON_GET_TIMEZONE_TEXT

TZON_GET_USER_TIMEZONE

TZ_LOCATION_TIMEZONE

Re: Current date for a time zone

RichHeilman — Wed, 17 May 2006 19:57:31 GMT

Please see the CONVERT TIME STAMP statement.

CONVERT for Timestamps

Converts a timestamp into the correct date and time for the current time zone

Syntax

CONVERT TIME STAMP <tst> TIME ZONE <tz> INTO DATE <d> TIME <t>.

CONVERT DATE <d> TIME <t> INTO TIME STAMP <tst> TIME ZONE <tz>.

As long as <tst> has type P(8) or P(11) with 7 decimal placed, and <tz> has type C(6), the time stamp <tst> will be converted to the correct date <d> and time <t> for the time zone <tz>.

Regards,

Rich Heilman

Re: Current date for a time zone

Former Member — Wed, 17 May 2006 19:58:33 GMT

hi amit,

try FMS

/SAPTRX/RANGE_CONVERT

CONVERT_TIME_TERMS

CIF_GEN3_CONVERT_DATETIME

CIF_GEN3_CONVERT_TIMESTAMP

CIF_GEN_CONVERT_DATETIME

CIF_GEN_CONVERT_TIMESTAMP

CIF_GEN4_CONVERT_DATETIME

CIF_GEN4_CONVERT_TIMESTAMP

CO_SF_CONVERT_TIMES_OPR

CXTP

DATE_TIME_CONVERT

POINT_IN_TIME_CONVERT

FITP_CONVERT_LOCAL_TIME_GMT

Tip : GO to -> SE37 and search key word TIME OR Convert

Regards,

Naveen

Re: Current date for a time zone

Former Member — Wed, 17 May 2006 19:58:53 GMT

Amit,

Also check F1 help on the command CONVERT DATE.

CONVERT DATE dat [TIME tim [DAYLIGHT SAVING TIME dst]]

INTO TIME STAMP time_stamp TIME ZONE tz.

Addition:

... DAYLIGHT SAVING TIME dst

Effect

This statement adopts a date specified in dat, a time specified in tim, and a daylight saving time selection specified in dst as the local date and time specification for the time zone specified in tz, converts it to the UTC reference time, and assigns the result to the time_stamp variable as a time stamp.

Re: Current date for a time zone

Former Member — Wed, 17 May 2006 20:01:36 GMT

Rick, This works when we already have the date and time for the time zone. My req is to find this date and time for the user specified zone. If you have some examples.. Please let me know.

Thanks

Amit

Re: Current date for a time zone

former_member181966 — Wed, 17 May 2006 20:02:55 GMT

try

/SOMO/GET_TIMEZONE

GET_SYSTEM_TIMEZONE

TIMEZONE

TIMEZONE2

TZON_GET_USER_TIMEZONE

Hope this’ll give you idea!!

P.S award the points.

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

Re: Current date for a time zone

RichHeilman — Wed, 17 May 2006 20:19:37 GMT

You will have to find out what the ajustment is for your time zone. Here is a sample program which uses the ajustments going backward and forward.



report zrich_0001.

data:  tstamp type timestamp,
       datum  type datum,
       uzeit  type sy-uzeit,
       new_date type sy-datum,
       new_time type sy-uzeit,
       stamp(14) type c,
       time_zone_adjustment(6) type c,
       index(2) type c.


set country 'US'.

datum = sy-datum.
uzeit = sy-uzeit.

* Go back
do 12 times.

  index = sy-index.
  concatenate 'UTC+' index into time_zone_adjustment.
  condense time_zone_adjustment no-gaps.

  convert date datum time uzeit into
          time stamp tstamp time zone time_zone_adjustment.

  clear stamp.
  stamp = stamp + tstamp.

  new_date = stamp+0(8).
  new_time = stamp+8(6).

  write:/ new_date, new_time.


enddo.


skip 1.


* Go forward
do 12 times.

  index = sy-index.
  concatenate 'UTC-' index into time_zone_adjustment.
  condense time_zone_adjustment no-gaps.

  convert date datum time uzeit into
          time stamp tstamp time zone time_zone_adjustment.

  clear stamp.
  stamp = stamp + tstamp.

  new_date = stamp+0(8).
  new_time = stamp+8(6).

  write:/ new_date, new_time.


enddo.

Regards,

Rich Heilman

Re: Current date for a time zone

nishanthbhandar — Thu, 18 May 2006 11:10:55 GMT

Amit,

You can make use of the below system fields :

SY-DATLO -- Date and Time,Local date of user

SY-TIMLO -- Date and Time,Local time of user

SY-ZONLO -- Date and Time,Time zone of user

Please reward helpful answers

Cheers

Nishanth