'date' data-type
| From: | Russell John Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | 'date' data-type | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5097@lists.php.net to get a copy of this message | ||
Hi all:
I seem to be having trouble specifiying a field length for my 'date'
data type in the mysql shell.
I'm using mysql-3.22.32
mysql>create table my_table (theDate date (8)); //This is not my
actual table but the date part exists in it as outlined above.
mysql outputs it's usual: You have an error in your SQL syntax near '(8))' at line 1
I am thinking that it uses the same syntax for assigning a length value
as does varchar or int etc etc, what's wrong - anyone??
Russ
--------------------------------------------
"Believe nothing - consider everything"
Russ Michell (APU webteam)
r.j.michell@anglia.ac.uk
ext 2331