Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved PB2017 R3 Time zone Support

  1. How-to
0
Votes
Undo
  1. Jeyakumar Chinnapillai
    Jeyakumar Chinnapillai
  2. PowerBuilder
  3. Wednesday, 17 October 2018 07:07 AM UTC

Does PB2017 R3 support Time zone offset and display the time in client time zone?

PB SVN client error code: 155036
CacheName in PB2017
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 October 2018 14:25 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Jeyakumar ;

  Unfortunately, PB does not support a Time Zone feature at this time (no pun intended).

However, you have two alternatives that I can suggest:

  1. Use the Time Zone SDK features of the MS-Window's O/S
    • FUNCTION  Boolean  SystemTimeToTzSpecificLocalTime (os_time_zone_information lpTimeZone, os_systemtime lpUniversalTime, ref os_systemtime lpLocalTime ) Library "kernel32"
  2. Use your DBMS time zone functons
    • ie: In SS or ASE ...  TODATETIMEOFFSET ( expression , time_zone )

HTH

Regards ... Chris

Comment
There are no comments made yet.
Responses (3)
Jeyakumar Chinnapillai
Jeyakumar Chinnapillai Accepted Answer Pending Moderation
  1. Thursday, 18 October 2018 09:03 AM UTC
  2. PowerBuilder
  3. # 1

Thanks!

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 17 October 2018 14:42 PM UTC
  2. PowerBuilder
  3. # 2

A couple of my examples use that function. Look at this one:

http://www.topwizprogramming.com/freecode_filesys.html

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.