24 Hour time format

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

24 Hour time format

Post by Nagaraj »

How do i say that use 24 hour format or not to use 24 hour format in this below function.

Oconv(@time, "MTS")
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

oh got it

OCONV(TIME(),"MTHS"))

Ray has already answered this question.

Lose the "H" from the time conversion, which specifies a 12-hour clock. No "H" specifies a 24-hour clock.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Handy, that Search functionality!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

Yeah....... i wish this search engine was more user friendly.....! like word suggestions etc like google :) :) ....! i know one day it will be much more better than it is today.
Post Reply