"Joel Gacosta" <joel@bluemediacomm.com> wrote in message
news:eDCuiIRSDHA.2316@tk2msftngp13.phx.gbl...
> Hi All!
>
> Is there a way in Date Time String Transformation Properties to convert
the
> time format to 24H? I have tried all the date format but i don't see any
24H
> format. Please help.
>
> Thanks
>
>

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:3f11226d$0$18761$afc38c87@news.easynet.co.uk...
> Hi
>
> If you are storing the information in a datetime datatype then you can
> choose the display format when retrieving the data using the convert
> command. If this is a character data type then you would have to specify
the
> format of the input such as yyyy-mm-dd hh:sstt and the format of the
output
> as yyyy-mm-dd HH:ss. (as HH is 24 hour format). Although there are some
> formats already available in the dropdown list, you can always type in
your
> own.
>
> John
>
>
> "Joel Gacosta" <joel@bluemediacomm.com> wrote in message
> news:eDCuiIRSDHA.2316@tk2msftngp13.phx.gbl...
> > Hi All!
> >
> > Is there a way in Date Time String Transformation Properties to convert
> the
> > time format to 24H? I have tried all the date format but i don't see any
> 24H
> > format. Please help.
> >
> > Thanks
> >
> >
>
>