MySQL: Data as Date

**The Hobo** · May 29th, 2002, 07:16 PM

How do you enter a date into a MySQL field? I've been trying to do it like this:

PHP Code:


date("Y-d-m")

But it keeps coming out as: 0000-00-00

**cpradio** · May 29th, 2002, 07:28 PM

I tend to do mine like so:

PHP Code:


$date = date("Y-d-m");

mysql_query("insert into tableName (completeDate) values ('$date')";

**The Hobo** · May 29th, 2002, 08:14 PM

This doesn't help me at all.

I just can't figure this out

**cpradio** · May 29th, 2002, 09:34 PM

make sure the field type varchar and not int

**The Hobo** · May 29th, 2002, 09:56 PM

the field is date

**cpradio** · May 29th, 2002, 10:15 PM

oh. I always used varchar and never had any problems, and I have no idea how date works.

**The Hobo** · May 29th, 2002, 10:37 PM

I just realized I had the format wrong. It needs to be:

PHP Code:


date("Y-m-d")

Thread: MySQL: Data as Date