--- Mukesh Kumar <[EMAIL PROTECTED]> wrote:
> Dear all,
>
> Can any body guide me how to insert into date field
>
> mysql_query("CREATE TABLE ft02tbl (
> ft02 int(11) NOT NULL auto_increment,
> a0 varchar(255) NOT NULL default '',
> a1 varchar(2) NOT NULL default '',
> a2 varchar(255) NOT NULL default '',
> a3 varchar(255) NOT NULL default '',
> a4 varchar(50) NOT NULL default '',
> a5 varchar(255) NOT NULL default '',
> a6 varchar(255) NOT NULL default '',
> a7 varchar(255) NOT NULL default '',
> a8 varchar(255) NOT NULL default '',
> a9 varchar(255) NOT NULL default '',
> a10 varchar(255) NOT NULL default '',
> a11 date NOT NULL default '00/00/0000' ,
> a12 varchar(255) NOT NULL default '',
> a13 varchar(5) NOT NULL default '00:00',
> a14 date NOT NULL default '00/00/0000' ,
> a15 varchar(5) NOT NULL default '00:00',
> a16 varchar(2) NOT NULL default 'o',
> a17 text,
> a18 text,
> a19 varchar(255) NOT NULL default '',
> a20 varchar(255) NOT NULL default '',
> a21 varchar(255) NOT NULL default '',
> a22 varchar(255) NOT NULL default '',
> a23 varchar(255) NOT NULL default '',
> a24 varchar(255) NOT NULL default '',
> a25 varchar(5) NOT NULL default '00:00',
> a26 varchar(2) NOT NULL default 'Y',
> a27 varchar(2) NOT NULL default 'N',
> a28 varchar(55) NOT NULL default 'N',
> a29 text,
> PRIMARY KEY (ft02)
> ) TYPE=MyISAM") or die("update error due to :" . mysql_error());
>
>
> mysql_query("insert into ft02tbl
> (a0,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a17,a18,a19,a20,a
> 21,a22,a23,a24,a25,a26,a27,a28) values
> ('name','n','1','1418','24','Email','url','pone','sdf','jhkj','kj',2005-24-0
> 1,'lkjlkjlkjl;kjhkjhkj;kjhkjkj;kjhkjk','17:16',2005-29-10,'4:13','y','a17','
> a18','a19','a20','a21','a22','a23','a24',9999,'Y','N','admin') ") or
> die("update error due to :" . mysql_error());
The format for the MySQL date datatype is YYYY-MM-DD. That's a 4-digit year,
followed by a 2-digit month, and a 2-digit day. You seem to be reversing the
last two. There is no month 24 or 29 :)
I assume you are aware that MySQL also has a datetime format which uses
YYYY-MM-DD HH:MM:SS
When you want to display dates in formats other than the MySQL default you
should use the DATE_FORMAT(fieldname,'format string') function since it can
deal with a range of dates from the year 1000 to 9999. PHP is usually limited
by the operating system to dealing properly with dates after 1 Jan 1970, the
epoch date for Unix systems.
James
_____
James
James D. Keeline
http://www.Keeline.com http://www.Keeline.com/articles
http://Stratemeyer.org http://www.Keeline.com/TSCollection
http://www.ITeachPHP.com -- Free Computer Classes: Linux, PHP, etc.
Fall Semester Begins Sep 7 -- New Classes Start Every Few Weeks.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
