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.