Other Languages

jast76 · September 20 '08, 09:22 AM (#1)

Hello everyone! I'm in need of some help with MY SQL. I'm relatively new to SQL and trying to create table in a database with a column for a date format of yymm. How would I go about this? Or would I do something like this;

PurchaseDate DATE (YYMM),

or would I define the date column with a contraint any help with this would great.

Thanks,
Jake

smoseley · September 20 '08, 12:53 PM (#2)

You can't constrain a date like that. I've used all of the following in the past:

VARCHAR(4) (YYMM)
MEDIUMINT (YYYYMM but formatted in the query to YYMM)
DATE (YYYY-MM-01, but formatted in the query to YYMM)

Good luck!

Other Languages

Help with MY SQL.