datetime columns

hi, is there a function in ms-sql to get the date only from a datetime
column

example
column 2006-09-26 00:00:00

i would like to see 2006-09-26

tia
Davedavep wrote:

Quote:

Originally Posted by

hi, is there a function in ms-sql to get the date only from a datetime
column
>
example
column 2006-09-26 00:00:00
>
i would like to see 2006-09-26
>
tia
Dave

There is no date-only datatype. SQL Server can't control how your
application displays a DATETIME. You need to use the facilities of your
client application or programming environment to format the date
correctly for display.

The other option would be to convert the date to a string (see CONVERT
in Books Online) but that's not usually a very desirable or convenient
way to handle dates.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--|||Where do you want to show data?
If you use front end application, do the formation there

Madhivanan

davep wrote:

Quote:

Originally Posted by

hi, is there a function in ms-sql to get the date only from a datetime
column
>
example
column 2006-09-26 00:00:00
>
i would like to see 2006-09-26
>
tia
Dave

|||Just take the first 10 characters, if you're looking for
something to display.|||thank you much all....
in this instance it is a client side web page building a query string user
enters standard date
so convert() work gr8 for the 1st 10 chars....

have a gr8 day
thanks again
dave p

"davep" <dvs_bis@.sbcglobal.netwrote in message
news:fQeSg.16681$IA.2714@.newssvr11.news.prodigy.co m...

Quote:

Originally Posted by

hi, is there a function in ms-sql to get the date only from a datetime
column
>
example
column 2006-09-26 00:00:00
>
i would like to see 2006-09-26
>
tia
Dave
>
>