|
Posted by David Portas on 09/26/06 19:38
davep wrote:
> 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/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|