Select date value 1

[PsychoCoder]

OK,

I have a web application Im working on in .Net, I do a query to retrieve certain information from a table, one of them being a datetime value. The column holds only the date (no time) but when I select it out it gives a time of 12:00AM by default, how can I get only the date?

 

[gmmastros]

The only way to remove the time is to convert the DateTime to a string (not in the table, but in the select that returns the data). Take a look at this.

Select Convert(VarChar(10), GetDate(), 101)
Select Convert(VarChar(11), GetDate(), 100)
Select Convert(VarChar(11), GetDate(), 102)
Select Convert(VarChar(11), GetDate(), 103)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[PsychoCoder]

gmmastros,

Thank you so much, I forgot that I had to convert it before pulling it out.

 

[ESquared]

This could be treated as a presentation issue... Display the date in the web application without the time, no matter what time might be attahed to the date, including 12am...