how to insert datetime into database using ASP?

[Bon]

Dear all

How can I convert a datetime in Short Date format to General Date
format and then insert into SQL database?

I get a date from a field using Request("in_date"), which is in Short
Date format. Afterwards, I need to convert it into General Date and
then insert the date into database. But, the date is always inserted as
1/1/1900. Please give me some suggestions.

Cheers
Bon

 

[Bobbo]

How can I convert a datetime in Short Date format to General Date
format and then insert into SQL database?

You're best off avoiding tampering with date formats wherever possible
- try to just store the date early on and format it when it's being
read back out of the database. This way helps to avoid regional
descrepancies and such.

the date is always inserted as
1/1/1900. Please give me some suggestions.

This could be happening for one of several reasons:

1. You're working on some kind of history database and the original
date entered was the 1st Jan 1900. I'm guessing this is the least
likely option.
2. Your format conversion code has a bug. See my comment earlier.
3. The date isn't being passed to the table correctly and it has a
default value set, which is being picked up.
4. Something else bad is happening.

 

[Bob Barrows [MVP]]

Dear all

How can I convert a datetime in Short Date format to General Date
format and then insert into SQL database?

I get a date from a field using Request("in_date"), which is in Short
Date format. Afterwards, I need to convert it into General Date and
then insert the date into database. But, the date is always inserted
as 1/1/1900. Please give me some suggestions.

http://www.aspfaq.com/show.asp?id=2040

 

[Egbert Nierop \(MVP for IIS\)]

Dear all

How can I convert a datetime in Short Date format to General Date
format and then insert into SQL database?

I get a date from a field using Request("in_date"), which is in Short
Date format. Afterwards, I need to convert it into General Date and
then insert the date into database. But, the date is always inserted as
1/1/1900. Please give me some suggestions.

I would not convert it yourselves. A difference in the country setting of
SQL and your current thread on ASP could cause difficulties already.

Set cmd = CreateObject("ADODB.Command")
'samples, assume field2 and field1 dates

set cmd.activeconnection = myconn

cmd.commandtext = "INSERT INTO myTable(field1, field2) VALUES(?,?)"
cmd.commandtype =1
cmd.parameters.append cmd.createparameter(, 135,,,CDate(mydate))
cmd.parameters.append cmd.createparameter(, 135,,,#1-1-2025#)
cmd.execute ,, 128