Insert timestamp into SQL Server 2000 using .asp - yes this is old stuff
<p>I am trying to insert a time stamp into SQL Server 2000 using classic ASP. The rest of the string works except for the timestamp. I am getting a blank insert with this query.  </p>

<pre><code>sActionSQL = "Insert Into [mydatabase].dbo.AppUsers" 
sActionSQL = sActionSQL &amp; " ([UserID], [AuthorityLevel], [Stores], [Area],     
[Password], [DateAdded])"
sActionSQL = sActionSQL &amp; " Values ('" &amp; UCase(Request.Form("UserID")) &amp; "'"
sActionSQL = sActionSQL &amp; " , " &amp; Request.Form("AuthorityLevel") 
sActionSQL = sActionSQL &amp; " , '" &amp; Request.Form("Stores") &amp; "'"
sActionSQL = sActionSQL &amp; " , '" &amp; Request.Form("cboAreaDirector") &amp; "'"
sActionSQL = sActionSQL &amp; " , '" &amp; sUserPassword  &amp; "'"
sActionSQL = sActionSQL &amp; " , '" &amp; (CURRENT_TIMESTAMP) &amp; "')    
</code></pre>

<p>The <code>DateAdded</code> column is a <code>varchar(50)</code>. Should I be using <code>CURRENT_TIMESTAMP</code> or <code>DATEADD</code>? </p>