SqlServer-QA.net

Just a bit of basics about DateTime datatype in SQL Server, it has two different date/time columns. They are DATETIME and SMALLDATETIME and the difference between these two SQL Server date/time data types. SQL Server has a number of default formats it expects raw date and time data to be in when inserting dates into a DATETIME, or SMALLDATETIME ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Reporting ServicesNotification Contents: New, All Modifications and Delete FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a ...

Hi there, In one of my query i am trying to get the date in 'Jan 01 2007' format. but when i try to sort this format it is giving me wrong result. i am using the convert fucntion to get the date in this format. Convert(char(12),strDate,10) Is there any other way to get the date in this format without converting the date to ...

Now-a-days it became common practice for newbies to varchar datatype to store dates. My first advise is to use proper DATETIME datatype. Sometimes it is preferred to use varchar when importing dates from other systems(to avoid any errors if the source dates are in different format). In that case it is required to see if values are ...

Mantle51: Hello, Is there a straight-forward way to convert this defaulted format 2026-08-01 00:00:00.000as 260801?  Many thanks.............Mickey It depends on where you want to show data. If you use front end application, use format function there

Mickey You could use CONVERT function, but I would like to refer the http://sqlserver2000.databases.aspfaq.com/can-i-make-sql-server-format-dates-and-times-for-me.html article that helps you and this one too http://www.sql-server-performance.com/articles/dev/datetime_datatype_p1.aspx a lot.

There might be various questions in the forums asking what is the default datetime format in SQL Server, how to change the date format. Further into the details  make a note that there is no international standard for representation of datetime values. ISO-8601 has a huge number of options, and SQL Server accepts at least a couple of ...