Date Problem

[Dashley]

This is my first shot at MYSQL. Im and Oracle user.
I'm doing an insert:
INSERT INTO SELLERS(email, first_name, last_name, add1, add2, city, state_Prov, zip5, zip4, postal_code, country, pwd, created) VALUES ('3','2','3','4','5','6','7','8','9','11','12','111111', '11/23/2004 9:31:12 PM')

When I look into the MYSql DB with my MYSql Query browser I see the following data there. The date is wrong though its all zeros's (Last Field) :'6', '1234', '21', '12', '1212', '21', '12', '12', '12', '12', '12', '12', '333333', '0000-00-00 00:00:00', ''


Any Ideas? BTW I'm using This DB undeer ASP with MYSQL server 4.1

Thanks

Dan

 

[r937]

the reason the date is all zeros is because mysql did not recognize your date value and therefore set the value to the default

mysql insists that all date values be presented in year-month-day sequence

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[Dashley]

r937

Thanks. Its working fine now thanks to you.
This MySql Is some neat stuff HA. I have to get unused to Oracle HA

Dan