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



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.

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

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