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'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 ...

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 ...