MSSQL SERVER timestamp datatype question

[Anon]

I need to store a variable into a colum that needs to be a dataabase date value; so when I query the table I can ORDER BY date ASC or DESC

I am having trouble inserting data into the timestamp colum this is the format that I want to store into the colum

10-01-2002 (day-month-year)

I get an error when I try to insert this format, I have no idea how to do this with MSSQL SERVER Please help

Thanks

/////////////////My table//////////////////

doc_number varchar(15)
reason text(16)
purpose text(16)
author varchar (60)
date_created timestamp(8)

this is the variable that I created to insert into the colum date_created

$date=date("d-m-Y");

I think I need to set this variable on the database side I am not sure.

MSSQL SERVER 2000, php 4.04

[tomhath]

Use "datetime" as the column type when you want to store a specific date.

What you have (timestamp) is compleely different, the DBMS will populate that column type automatically like an IDENTITY column.