-
From: Frank Keessen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 1:21 AM
To: Philip Hallstrom
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Forms and MySql date
Hi,
You can let the users enter a date as 20-02-2003 into a textfield with the
name $userdate
Then you can use this function
I apologize
the correct order is -MM-DD so you would do:
$mysqldate = $_POST[year].-.$_POST[month].-.$_POST[date];
-Original Message-
From: v0idnull [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 21, 2003 4:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Forms and MySql date
I have a form that I want to enter a date into a MySql database. I
currently have the column in the database set as Date, and can't seem
to get the date I enter into the text field to go into the database
using the format yymmdd. I could change the column to varchar, and then
it would enter, but
: [PHP] Forms and MySql date
I have a form that I want to enter a date into a MySql database. I
currently have the column in the database set as Date, and can't seem
to get the date I enter into the text field to go into the database
using the format yymmdd. I could change the column to varchar
- Original Message -
From: Philip Hallstrom [EMAIL PROTECTED]
To: Mike Tuller [EMAIL PROTECTED]
Cc: php mailing list list [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 11:48 PM
Subject: [PHP] Re: Forms and MySql date
You could use the TO_DATE function to convert that text string
5 matches
Mail list logo