SQL Server data types

spinout · September 21st, 2004, 12:31 AM

Hello,

I am using the 'datetime' datatype for a column in one of my databases which seems to write to the database as "2004-09-21T00:00:00".
I was wondering if there is a datatype I could use where I'll still get the date written to the column but without the time rubbish on the end of it?

qazi_nomi · September 21st, 2004, 12:46 AM

As for as the sql server it is the only one data type for date and time and it depends on your language which you are using to provide the value to the column. So that language only provide it the date value and not time. Like ASP has different functions for date and time so you can provide sql only date value to that columns

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find it and grab it!

spinout · September 21st, 2004, 12:52 AM

The strange thing is when I view the data in Enterprise Manager (by going Open Table --> Return All Rows) it only displays the date as "21/09/2004" which is exactly how I want it.

But when I run a query in Query Analyzer or query the results using XML that's when I get the "2004-09-21T00:00:00" so I'm a bit confused.

qazi_nomi · September 21st, 2004, 01:14 AM

Dear when you display the result you only display date instead of both

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find it and grab it!

happygv · September 22nd, 2004, 05:02 PM

Hey spinout,

Use this in your queries to get the format what you are looking for.

Code:

select convert(varchar(10),DATETIME_COLUMN,103)

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

r_ganesh76 · September 23rd, 2004, 02:27 AM

You can create a view in which you can select the date column in your specific format and use the view in your application

Regards
Ganesh