Does anyone know the syntax in a insert statement for the data type timestamp. The user has a input box where they enter in a date on the web-side. The internal users need the time part, so it is stored as a timestamp. The web-side user doesn't have to enter in a time, but I get an ERROR ON MY INSERT STATEMENT because of this data type involvement of the time.<BR><BR>sql= "INSERT INTO Trade_Name(Trade_Name, Start_Date, End_Date ) "<BR><BR>sql=sql & "Values(" & "'" & request ("Trade_Name") & "','"<BR>sql=sql & Request("Start_Date") & "','"<BR>sql=sql & Request("End_Date") & "')"<BR><BR>Thanks for any help. I'm using sybase with the possibility to switch over to oracle.