Hello, I have a smalldatetime field in my sql table. I would like to show it in a specific format in my queries. As much as i searched, i couldn't find this format in mssql 2005; dd/mm/yyyy hh:mm. this is the exact format i need. anything else is no good. Any idea? Thanks
But the most important thing is, don't count on SQL Server for formatting. That's what your front-end code is for. SQL Server should store the information in a useful manner. Your application, report, or spreadsheet can then format it appropriately.