hour separator from . to : ?!?!

In my SQLserver DATA datatype appear to me with hour separator "."
(12.00.00)
I want that they appear with separator ":" (12:00:00) (for to prevent ODBC
problems)
(I have changed the international setting of the server... the OS time is
changed, but in the DB I always have the ".")
Any suggestions?
Is this a dattime datatype? If so it is not stored with any type of
delimiter. Internally it is stored as two Integers and it is up to the
front end to display it however they wish. So if it's displaying with a .
you need to look at your GUI or the driver being used. You can also convert
the datetime to a string with CONVERT() to display it in many different
formats. But as a pure datetime it does not have a display format. See
CONVERT() in BOL for more details.
Andrew J. Kelly SQL MVP
"YURYSSG" <yuryssg@.yahoo.it> wrote in message
news:2qlj83F10pofdU1@.uni-berlin.de...
> In my SQLserver DATA datatype appear to me with hour separator "."
> (12.00.00)
> I want that they appear with separator ":" (12:00:00) (for to prevent
ODBC
> problems)
> (I have changed the international setting of the server... the OS time is
> changed, but in the DB I always have the ".")
> Any suggestions?
> --
>
>
|||If you are using the SQL Server ODBC driver, and you are using the driver to
convert from DATETIME to string (ie. binding the column as SQL_C_CHAR), then
you should be able to change the seperator characters using the Regional
settings on the client machine.
Brannon
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:#B$JQaZmEHA.2020@.TK2MSFTNGP09.phx.gbl...
> Is this a dattime datatype? If so it is not stored with any type of
> delimiter. Internally it is stored as two Integers and it is up to the
> front end to display it however they wish. So if it's displaying with a .
> you need to look at your GUI or the driver being used. You can also
convert[vbcol=seagreen]
> the datetime to a string with CONVERT() to display it in many different
> formats. But as a pure datetime it does not have a display format. See
> CONVERT() in BOL for more details.
> --
> Andrew J. Kelly SQL MVP
>
> "YURYSSG" <yuryssg@.yahoo.it> wrote in message
> news:2qlj83F10pofdU1@.uni-berlin.de...
> ODBC
is
>
|||In the worst case if the above do not work you can always use Replace after
you converted it to string and return it as a string.
"Brannon Jones" <brannonjNOSPAM@.gmail.com> wrote in message
news:OphvrcfmEHA.512@.TK2MSFTNGP10.phx.gbl...
> If you are using the SQL Server ODBC driver, and you are using the driver
> to
> convert from DATETIME to string (ie. binding the column as SQL_C_CHAR),
> then
> you should be able to change the seperator characters using the Regional
> settings on the client machine.
> Brannon
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:#B$JQaZmEHA.2020@.TK2MSFTNGP09.phx.gbl...
> convert
> is
>