Thanks ... I can't believe I missed that in the docs ... now I feel like knob. Michael. On Thu, 8 Jul 2004 14:17:38 -0300 "Pablo M. Rivas" <pmrivas01@xxxxxxxxxxxx> wrote: > Hello Michael, > token_date must be a DATE FIELD... > > http://dev.mysql.com/doc/mysql/en/Column_types.html > > > MG> Hello, > > MG> I need to store the date of record / entry in the mysql database, so I have the following table create > MG> statement: > > MG> CREATE TABLE `token_table` ( > MG> `token_id` int(11) NOT NULL auto_increment, > MG> `token_utuser_id` int(11) NOT NULL default '0', > MG> `token_name` varchar(100) NOT NULL default '', > MG> `token_date` varchar(100) NOT NULL default '', > MG> `token_user_id` varchar(100) default '', > MG> `token_ticket_id` varchar(100) default '', > MG> `token_data` varchar(100) default '', > MG> PRIMARY KEY (`token_id`), > MG> KEY `tokencheck` (`token_utuser_id`,`token_name`) > MG> ) TYPE=MyISAM; > > MG> So in the token_date field I am storing the date in the following format from PHP: > > MG> date("d/m/Y") which creates the following entry "05/07/2004" (example). > > MG> I would like to know fro the list is ... is this the best way to store the date ? Would this be easy to select > MG> against ? > > MG> Michael. > > > > > -- > Best regards, > Pablo > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- Michael Gale Network Administrator Utilitran Corporation -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
