SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:30 PM
| |||
| |||
 Re: datetime columns 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/m...S,SQL.90).aspx --      |
|
02-29-2008, 08:30 PM
| |||
| |||
| Re: datetime columns Where do you want to show data? If you use front end application, do the formation there Madhivanan 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 |
|
02-29-2008, 08:31 PM
| ||||
| ||||
| Re: datetime columns thank you much all..... in this instance it is a client side web page building a query string user enters standard date so convert() work gr8 for the 1st 10 chars..... have a gr8 day thanks again dave p "davep" <dvs_bis@sbcglobal.net> wrote in message news:fQeSg.16681$IA.2714@newssvr11.news.prodigy.co m... > 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 > > |
 |
« Insert Japanese from ASP page into MSSQL Server 2000 database
|
Recover Mode set to Simple for Unknown Reason (not MSDB) »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 03:19 AM.
