RE: [PHP] Re: how can i insert date
| From: | John Holmes | Date: | Thu, 13 Jun 2002 16:33:55 +0000 |
| Subject: | RE: [PHP] Re: how can i insert date | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-101991@lists.php.net to get a copy of this message | ||
INSERT INTO table (date_column) VALUES ('$insert');
If you're using a varchar() type column, then that'll work. If it's a
DATE/DATETIME/etc... column in your DB, then you have to format it in
the DB format...
What DB are you using?
---John Holmes...
> -----Original Message-----
> From: Cirstoiu Aurel Sorin [mailto:csorin@interakt.ro]
> Sent: Thursday, June 13, 2002 4:03 AM
> To: php-general@lists.php.net
> Subject: [PHP] Re: how can i insert date
>
> You make a variable $insert = $year."/".$month."/".$date(or whatever
> format
> you wish) and insert it in the database.
>
> --
> --------------------------------
> Cirstoiu Aurel Sorin
> InterAKT Support
>
> http://www.interakt.ro
> --------------------------------
> "Suman" <mansu@softhome.net> wrote in message
> news:200206130350.02013.mansu@softhome.net...
> hi
> i have a date,month and an year what is the function in php that i can
i
> use
> to convert the 3 vars into a date and insert into a postgres db.
>
> bye
> suman
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php