Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.

I just added a field, 'ExportDate' to a table (AYP) in my MS SQL 2000 database. Since I added the field to an existing table, the values for 'ExportDate' in all records is <null>.<P>What I need to ...

I've been forced to take over a .asp report page that pulls data from MSSQL.The table I'm pulling data from has a field which is of the SQL datetime data type. I want to display this value as text ...