inserting date into mysql
Kiran Annaiah <[email protected]> Wed, 31 Oct 2007 15:10:41 -0500
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
HI, I am having trouble inserting date into my table (Mysql) my sql statement looks like this... Example: update tableA set sdate='1/1/2007' where c=1; That doesnt do anything. I see there are diff formats in mysql for date. But i didnt see any for entering date as mm/dd/yyyy Any tips and suggestions would be of great help thank you all:) Kiran _________________________________________________________________ Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews