Re: How to Insert date in sql server database
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 6 Jun 2006 12:58:32 +0000 (UTC)
SSG (ssg14j@xxxxxxxxx) writes:
How to insert date to the sql server database.
I am getting input from the HTML form and store it to database using
ASP.
how to store date field, what datatype needed and what conversion
needed.
The data type to use datetime or smalldatetime. These always include
the time portion, but set it to midnight for dates only.
Conversion should occur in the client, by using parameterised statements.
Here is an example that I have canned of a parameterised statement in ADO
(it's VB6 and not ASP, but I believe that they are not too different):
Set cmd = CreateObject("ADODB.Command")
Set cmd.ActiveConnection = cnn
cmd.CommandType = adCmdText
cmd.CommandText = " SELECT OrderID, OrderDate, CustomerID, ShipName " & _
" FROM dbo.Orders WHERE 1 = 1 "
If custid <> "" Then
cmd.CommandText = cmd.CommandText & " AND CustomerID LIKE ? "
cmd.Parameters.Append
cmd.CreateParameter("@custid", adWChar, adParamInput, 5, custid)
End If
If shipname <> "" Then
cmd.CommandText = cmd.CommandText & " AND ShipName LIKE ? "
cmd.Parameters.Append cmd.CreateParameter("@shipname", _
adVarWChar, adParamInput, 40, shipname)
End If
Set rs = cmd.Execute
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prev by Date: Re: Divide by zero error!!! Help!
- Next by Date: SQL Union Problems When Trying to Retrieve Random Records
- Previous by thread: How to Insert date in sql server database
- Next by thread: Divide by zero error!!! Help!
- Index(es):
Relevant Pages
|
