Let him first read this book: "How Computer Programming Works" from Daniel Appleman. A great book for children (and mortals who don't understand anything about computing): http://www.apress.com/book/view/9781893115231[^]

Goodway, First of all I assume you use SQL Server (7.0/2000). If not quit reading. Then, SQL Servers date/time datatype always consists of a date AND a time part. A date without a time component does not exsist is SQL Server. If you insert a date value without a time, for example jan 1, 2004, SQL Server inserts the date as 2004/01/01 00:00:00.000 (for smalldatetime skip the milliseconds). So if you need a date without a time you need to convert a datetime value to a string. You can use the CONVERT-function in SQL (see "CAST and CONVERT" in SQL Books online). Example: SELECT CONVERT (varchar(24), GetDate() , 103); Returns: 01/01/2004 -- Note: the result is a string. Not a datetime value. Good luck