1. N P
  2. PowerBuilder
  3. Thursday, 26 April 2018

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



Bruce Armstrong Accepted Answer Pending Moderation

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.


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"  .




  1. N P
  2. Thursday, 26 April 2018
For numbers use the format string "00.00" to get "05.02".

  1. René Ullrich
  2. Friday, 27 April 2018
There are no comments made yet.
  1. Thursday, 26 April 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.