Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
date format in SQL Server
Name: bismarkcount Date: July 12, 2007 at 07:36:50 Pacific OS: windows xp CPU/Ram: 1gb Product: dell
Comment:
Hi! i would like some help to figure this out:
How can i select a datetime field in sql server in an specific format?
ie: when i execute: select (datefield) from table the result is something like: 07/12/2007 09:34
is there a way to do something like this oracle sentence for SQL Server?: select to_char(datefield, 'mm/dd/yyyy') from table
Summary: I have developed a few reports on SQL Server 2008+VS 2008 and deployed them to the SSRS built in reporting URL (http://servername/reports) During the report creation I have used SQL authentication for...
Summary: Hey All, I think I may have a corrupt table in SQL Server. When I go in through Enterprise Manager and I right click on one of my tables the following error message comes up: Error 21769: [SQL-DMO] T...