Re: hour separator from . to : ?!?!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Brannon Jones (brannonjNOSPAM_at_gmail.com)
Date: 09/14/04 

Date: Mon, 13 Sep 2004 18:06:14 -0700

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
> 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???
> >
> > --
> >
> >
> >
>
>

Relevant Pages

  • Re: hour separator from . to : ?!?!
    ... If you are using the SQL Server ODBC driver, and you are using the driver to ... convert from DATETIME to string, ... > front end to display it however they wish. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Unable to get dri enabled
    ... to use the fglrx driver... ... display::0.0 screen: 0 ... OpenGL renderer string: MOBILITY/RADEON 9000 DDR Generic ...
    (Ubuntu)
  • [SLE] An nVidia/Sax issue I need help with
    ... 3D support going and in a round-about manner discovered my nVidia driver ... To be more specific the display seems to be about a quarter ... server glx vendor string: NVIDIA Corporation ...
    (SuSE)
  • Re: hour separator from . to : ?!?!
    ... you converted it to string and return it as a string. ... > If you are using the SQL Server ODBC driver, and you are using the driver ... >> front end to display it however they wish. ... But as a pure datetime it does not have a display format. ...
    (microsoft.public.sqlserver.odbc)
  • Re: hour separator from . to : ?!?!
    ... you converted it to string and return it as a string. ... > If you are using the SQL Server ODBC driver, and you are using the driver ... >> front end to display it however they wish. ... But as a pure datetime it does not have a display format. ...
    (microsoft.public.sqlserver.setup)