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

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 (AT) bluemediacomm (DOT) com> wrote

Great! I must format the input source into 24H first before i can have the
output in 24H else i would stuck in 12H even if I specify the output format
as HH:mm:ss. Thanx!

joel


"John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

Sorry i forgot to tell you that i'm converting from a character data type
and not a datetime data type.

ciao

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Hi

As you are using a datetime data type for the column, you may not need any
conversion for the time portion as SQLServer will understand it. Depending
on the input format, you may have problems with the month and day being
imported incorrectly, in which case a format will be needed for that.

When you want to select the data from the table you can convert it into a
formatted string using the convert function
see
http://msdn.microsoft.com/library/de...asp?frame=true

Such as

SELECT convert(varchar,datefld,108), convert(varchar,datefld,9) FROM MyTable

If you only want part of the string returned and convert does not give you
the exact format use the string functions RIGHT, LEFT or SUBSTRING
http://msdn.microsoft.com/library/de...asp?frame=true

John

"Joel Gacosta" <joel (AT) bluemediacomm (DOT) com> wrote