Posted by Peter Boosten on 08/03/06 20:12

walterbyrd <walterbyrd@iname.com> wrote:
> My MySQL table has a field that is set as type "date." I need to get
> today's date, and insert it into that field. The default for that MySQL
> field is 2006-00-00.
>
> I know about the date() function. I have tried date("Y-m-d") and
> date("U"), neither worked. The date field was just filed with all
> zeros.
>
> Can anybody point me in the right direction?
>
> Thanx.
>

now()

Peter

--
http://www.boosten.org

Mail: peter at boosten dot org

• Next in forum: Re: Calculate time between 2 timestamps
• Prev in forum: Problems installing PEAR on WinXP
• Thread view: Re: Put today's date into a MySQL "date" formated field

[Reply to this message]