Retrieving dates from SQL Server 2000

[mike55]

Hi

 

I am doing a select statement on a table via a stored procedure. One of the rows selected is of type datetime. I need to trim the date time in such a way that the date time is only in the format dd/mm/yyyy not dd/mm/yyyy hh:mm:ss. When I select the data I insert it into a dataset table, which is then binded to a datagrid. Any suggestions??

 

Mike55

[Afraits]

CONVERT(varchar(12),DateField,103) will return just the date part of the field without the time in the format dd/mm/yyyy.

 

Note that this will return the date as a string variable, if you want to keep it as a date (eg for sorting purposes) then using the datagrid to format the date to the desired format may be a better way of dealing with it.

[Robby]

If you want the format to take place at the datagrid level then add this "{0:D}" to the eval argument (2)

[kcwallace]

Is there a help file for this SQL Server Function I can read?

 

CONVERT(varchar(12),DateField,103)

 

meaning what if I use 101 instead of 103

[Mister E]

Is there a help file for this SQL Server Function I can read?

 

CONVERT(varchar(12),DateField,103)

 

meaning what if I use 101 instead of 103

 

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ca-co_2f3o.asp?frame=true