SQl Question-- DateTime

[lalitha1]

Can someone help me with this.
is it possible to display just the date part from a Datetime column in sqlserver 2000.
Want Output as ‘10/15/2008’ not ‘2008-10-15 00:00:00.000’

Thanks!

 

[RiverGuy]

Try this in a query window:

SELECT CONVERT(VARCHAR, GETDATE(), 101)

 

[lalitha1]

That works.Appreciate your help.

 

[lalitha1]

But if in a table if there are more than one DateTime columns how do I know which column am I refering to.
For example, in Employeetable there are two columns
startdate and Enddate. I would like to get the date part of just the Startdate.

 

[RiverGuy]

The code I posted above is an example. Replace the word "GETDATE()" with the name of your column(s). You can use this code multiple times within the same SQL statement.