quote:

---

Remarks
Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The first 4 bytes store the number of days before or after the base date, January 1, 1900. The base date is the system reference date. Values for datetime earlier than January 1, 1753, are not permitted. The other 4 bytes store the time of day represented as the number of milliseconds after midnight.

The smalldatetime data type stores dates and times of day with less precision than datetime. SQL Server stores smalldatetime values as two 2-byte integers. The first 2 bytes store the number of days after January 1, 1900. The other 2 bytes store the number of minutes since midnight. Dates range from January 1, 1900, through June 6, 2079, with accuracy to the minute.

---

USE Northwind
GO
SET NOCOUNT ON
SELECT CONVERT(smalldatetime,(LEFT(CONVERT(varchar(24),GetDate(),126),10))) AS NewDate INTO #myTemp99
SELECT * FROM #myTemp99
GO

SET NOCOUNT OFF
DROP TABLE #myTemp99
GO

USE Northwind
GO
SET NOCOUNT ON
SELECT CONVERT(datetime,CONVERT(varchar(24),GetDate(),101)) AS NewDate INTO #myTemp99
SELECT * FROM #myTemp99
GO

SET NOCOUNT OFF
DROP TABLE #myTemp99
GO

select convert(datetime,getdate(),101)

select convert(varchar(30),getdate(),101)

quote:

---

Originally posted by KidSQL

Thanks for the suggestion. I've tried this, but somehow I keep getting a YYYY-MM-DD date format. In fact, I keep getting this format even when I use one of the pre-packaged codes (101, for instance). Could it be somethign to do with some default setting I have, I wonder?

---