Ian O'Rourke wrote:
I'm very new to MySql and I'm having problems inserting dates into my tables
(via the Web using Coldfusion). The user can put the following in the field:
12/09/2003
But the data returned from the database is:
2012-09-20 03:00:00.0
INSERT INTO table (field)
VALU
Thanks a lot, time to look into my Coldfusion sting functions or Date_Format
in MySQL.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e:
> > I'm very new to MySql and I'm having problems inserting dates into my tables
> > (via the Web using Coldfusion). The user can put the following in the field:
> >
> > 12/09/2003
> > But the data returned from the database is:
> >
> > 201
On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote:
> I'm very new to MySql and I'm having problems inserting dates into my tables
> (via the Web using Coldfusion). The user can put the following in the field:
>
> 12/09/2003
> But the data returned from the database
Hi Ian
reverse the order of your date, i.e., 2003/09/12 or use the date format
function
hth
steve
Ian O'Rourke wrote:
I'm very new to MySql and I'm having problems inserting dates into my tables
(via the Web using Coldfusion). The user can put the following in the field:
12/
I'm very new to MySql and I'm having problems inserting dates into my tables
(via the Web using Coldfusion). The user can put the following in the field:
12/09/2003
But the data returned from the database is:
2012-09-20 03:00:00.0
So I'm a bit confused about what I need to d
