SQL Date format for credit card - TechRepublic
Question
November 18, 2010 at 03:19 AM
gavinjinks

SQL Date format for credit card

by gavinjinks . Updated 15 years, 7 months ago

Hi There, I am very new to MySQL and am creating a database for online payments etc. What datatype do I need to use for the credit card expiry date?

If i put in the DATE/TIME syntax then it comes up DDMMYYYY. I need to end up having MM/YY only and validated.

Could any one help me please?

Thanks in advance.

This discussion is locked

All Comments