Problem with insert dates in SQL

[Oswaldo]

Hi, I have a table with a camp "Fecha" (it is datetime).I
insert a date in this format: dd/mm/yy (for example
01/11/2003) but in the table the insert value is 1/1/1900.
I insert the value using ASP code. What is the problem?

Thanks and regards.

[Aaron Bertrand - MVP]

(1) Is that January 11th, or November 1st? I have no idea, and don't expect
your software to guess right either. Use an ISO standard date format, e.g.
2003-11-01 for Access, 20031101 for SQL Server.

(2) Make sure you are delimiting your dates correctly (sounds like you are
passing in 1/11/2003 directly, which is 1 divided by 11 divided by 2003, a
very small number indeed). For SQL Server, use

INSERT table(dateColumn) VALUES('20031101')

For Access, use

INSERT table(dateColumn) VALUES(#2003-11-01#)

In the future, please show the exact code you are using, and specify the
database and version. It makes it much easier to spot the problem and
suggest solutions.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Oswaldo" <jmendieta@comercio.com.pe> wrote in message
news:021f01c3b075$c6d25080$a501280a@phx.gbl...

> Hi, I have a table with a camp "Fecha" (it is datetime).I
> insert a date in this format: dd/mm/yy (for example
> 01/11/2003) but in the table the insert value is 1/1/1900.
> I insert the value using ASP code. What is the problem?
>
> Thanks and regards.