Sql server date format dd mm yyyy hh mm ss

Top sites by search query "sql server date format dd mm yyyy hh mm ss"

Understanding datetime formats in SQL Server - Database Administrators Stack Exchange

  http://dba.stackexchange.com/questions/63641/understanding-datetime-formats-in-sql-server
Why is SQL Server showing me the dates in a format that is not covertable or valid when applied back to itself? I don't have any problem in changing the date format when writing queries, but I want to play with these dates at an application level (Java-JDBC app) and I don't want to be applying date format changes all the time... Could anyone explain me why this is happening and if there is any way to solve it at a DB level? Thanks!! Edit: Please see the screenshot of the error in Management Studio below

  http://weblogs.sqlteam.com/jeffs/archive/2007/04/13/format-date-sql-server.aspx
In .NET applications, you can usually format dates in data bound controls using the GUI interface, and you can also format things using the ToString() method of a true datetime value and specify all kinds of simple yet flexible formatting strings. Isn't it much easier to simply right-click on something and then enter a simple "mmm dd, yyyy" format string instead of building and parsing this manually using CONVERT and SUBSTRING parsing in T-SQL? Isn't it more flexible to do all formatting at your presentation layer so that you can just return data from your database and not worry about how it looks? Then 5 different clients can query the same stored procedure and each output those dates any way they want -- without changing any database code

  http://blog.sqlauthority.com/2008/08/14/sql-server-get-date-time-in-any-format-udf-user-defined-functions/
Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=169835
)@visakh16: He stated earlier that he has a legacy system the he has to send this data over to, and it requires the data to be in that format, or it won't work. At any given time during the month, have separate query fields that show the date (in the format above) as at the first day of the month and the date of the last day of the month.Is this possible? I can't seem to find the correct code that will display the date in the format above