Re: How do I format data in the SQL statement
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/05/05
- Next message: Dan Guzman: "Re: Execute trigger as a specific user"
- Previous message: gopi: "Re: small yellow circles in execution plan"
- In reply to: Jim Warren: "Re: How do I format data in the SQL statement"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 5 Feb 2005 12:56:25 -0500
As I stated and Bob confirmed you would want to look at CONVERT() in
BooksOnLine. You can convert the decimal into an INT and that will loos the
decimal places.
-- Andrew J. Kelly SQL MVP "Jim Warren" <jmwarren@msu.edu> wrote in message news:OI$46h3CFHA.1836@tk2msftngp13.phx.gbl... > Sorry > > How do I make Number into zero decimal point i.e. 2.0000000 into 2. How do > I convert dates from 2005-1-14 to Jan 1, 2005. Is there a format statement > of some kind > > Thanks > Jim > > "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message > news:O9sU4llCFHA.1292@TK2MSFTNGP10.phx.gbl... >> That's a little vague but I think you are after CONVERT(). See >> BooksOnLine for more details. >> >> -- >> Andrew J. Kelly SQL MVP >> >> >> "Jim Warren" <jmwarren@msu.edu> wrote in message >> news:u0WUchlCFHA.392@TK2MSFTNGP14.phx.gbl... >>> It has been a couple of years but I remember being able to format >>> numbers, dates and text in SQL Server statements, can't find much in >>> online books , >>> Where can I relearn this, thanks >>> Jim >>> >> >> > >
- Next message: Dan Guzman: "Re: Execute trigger as a specific user"
- Previous message: gopi: "Re: small yellow circles in execution plan"
- In reply to: Jim Warren: "Re: How do I format data in the SQL statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
