i had no error it worked well.. but i wonder.. i entered a date like today 02-12-2003 but the table don t take it as a date it s varchar so if someone in my form enter some crazy stuff let s say 99-99-9999.... will it work or it will know it s not possible.. ?
Why not store the date in a DATE field? It will make it a lot easier to manipulate, VARCHAR's very limited when it comes to dates and times. Then you just use DATE_FORMAT() to retrieve the date in whatever format you want.
yeh I always store a timestamp and use
DATE_FORMAT() as well.. just giving him what he wants lol
twigletmac wrote:Why not store the date in a DATE field? It will make it a lot easier to manipulate, VARCHAR's very limited when it comes to dates and times. Then you just use DATE_FORMAT() to retrieve the date in whatever format you want.