• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Date-time & decimal value format in power builder .

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

Resolved Date-time & decimal value format in power builder .

  1. Issue
0
Votes
Undo
  1. N P
    N P
  2. PowerBuilder
  3. Thursday, 26 April 2018 15:59 PM UTC

Hi All,

I want to change the format of date time displayed without having to modify SQL query . Currently it is displaying "9/19/2017 08:29:25 "  i want to change it to "19 MAR 2017 08:29:25" . same case with decimal values , it is showing ".6" instead "0.6".

Thanks in advance

NA

 

  1. Build
  2. DATE
  3. Format
Can PowerBuilder 2018 and R3 Exist Side By Side?
PowerBuilder 2019
Responses (1)
Bruce Armstrong
Bruce Armstrong Accepted Answer Pending Moderation
  1. Thursday, 26 April 2018 17:20 PM UTC
  2. PowerBuilder
  3. # 1

Use the PowerScript String function.  You define a format that you want the data displayed in, but at that point it's a string.

Also, in the DataWindow you could use an Edit control with a format or an EditMask control with a Mask in the desired format.

Comment
N P
  1. N P
  2. Thursday, 26 April 2018 18:49 PM UTC
Bruce,



Thanks for your kind response. i was able to fix it in column format filed to mm/dd/yyyy h:mm:ss . I need some help with formatting numbers something like "05.20"  .



 



NA



 

  1. Helpful
René Ullrich
  1. René Ullrich
  2. Friday, 27 April 2018 05:24 AM UTC
For numbers use the format string "00.00" to get "05.02".

  1. Helpful
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.