Re: Date Format?
| From: | HP8570 | Date: | Wed, 29 Nov 2000 16:11:22 +0000 |
| Subject: | Re: Date Format? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-27909@lists.php.net to get a copy of this message | ||
If you want the to insert the current date in your query do:
INSERT INTO mytable SET Date=CRDATE();
That will enter todays date in the correct mySQL Date format.
Jason
Wee Chua wrote:
> Hi all,
> I would like to insert the current date into the date datatype field. How
> could I format the Now() into the correct format of date datatype? I would
> like to find the way to do it PHP and MySQL. Thanks in advance for any
> helps.
>
> Calvin Chua
> Systems Analyst
> InterClean Equipment, Inc.
> 734-975-2967
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net