Page 1 of 1

SQL INSERT DATE

Posted: Thu Nov 11, 2010 4:44 am
by ronipthomas
Hi guys...
Check this db query..
When i run this query, its inseted as 0000-00-00 00:00:00..
Can anybody help me??
fight_date type is datetime.


insert into wp_fights(`fight_date`) values ( '11-11-2010 10:35:26')

Re: SQL INSERT DATE

Posted: Thu Nov 11, 2010 4:49 am
by Weirdan
assuming it's MySQL you need to provide date in ISO 2014 format: YYYY-MM-DD

Re: SQL INSERT DATE

Posted: Thu Nov 11, 2010 4:53 am
by rahulzatakia
Hi, please use the following format in insert query:

insert into wp_fights(`fight_date`) values ('2010-11-11 10:35:26')

Re: SQL INSERT DATE

Posted: Thu Nov 11, 2010 5:10 am
by ronipthomas
Thanks Weirdan and rahulzatakia....