Seppo Apajalahti
|
| Posted: 11/06/2002, 11:42 AM |
|
Hi!
I have problems with dates. I use MySQL and PHP.
I made a form with a date -field. Here in Finland the format is allways
dd.mm.yyyy. But if I use this or any other format any data will go to
database. There is only 0000-00-00.
--
Seppo
|
|
|
 |
Tobias Weik
|
| Posted: 11/06/2002, 12:19 PM |
|
Seppo Apajalahti schrieb:
> Hi!
>
> I have problems with dates. I use MySQL and PHP.
> I made a form with a date -field. Here in Finland the format is allways
> dd.mm.yyyy. But if I use this or any other format any data will go to
> database. There is only 0000-00-00.
Hi Seppo,
easy thing with this: just go to your project-settings and define the used
date-format in your database (yyyy-mm-dd) and the date-format you want to use in
your project (dd.mm.yyyy).
Regards,
Tobias
|
|
|
|
Seppo Apajalahti
|
| Posted: 11/06/2002, 12:42 PM |
|
Hi!
I have try it, but it doesn't help. Not any will go to the database.
- Seppo-
"Tobias Weik" <tw@ccug.de> kirjoitti
viestissä:aqbtft$gtm$1@news.codecharge.com...
> Seppo Apajalahti schrieb:
> > Hi!
> >
> > I have problems with dates. I use MySQL and PHP.
> > I made a form with a date -field. Here in Finland the format is allways
> > dd.mm.yyyy. But if I use this or any other format any data will go to
> > database. There is only 0000-00-00.
>
> Hi Seppo,
>
> easy thing with this: just go to your project-settings and define the used
> date-format in your database (yyyy-mm-dd) and the date-format you want to
use in
> your project (dd.mm.yyyy).
>
> Regards,
> Tobias
>
|
|
|
|
RonB
|
| Posted: 11/06/2002, 10:18 PM |
|
Hi,
You do now that the list with dateformats in the properties section isn't
just a dropdownlist? I work with PHP and MySql this is what I do:
in Format I type dd-mm-yyyy
in DBFormat I TYPE yyyy-mm-dd
That's all now everything works fine. You can change the format in Format to
anything you want as long as you make sure that, for MySQL, the DBFormat
stays yyyy-mm-dd
The fact that you could type in a dropdownlist had me going in circels for a
while 
RonB
"Seppo Apajalahti" <seppo.apajalahti@pp.inet.fi> schreef in bericht
news:aqbusd$jkg$1@news.codecharge.com...
> Hi!
>
> I have try it, but it doesn't help. Not any will go to the database.
>
> - Seppo-
>
> "Tobias Weik" <tw@ccug.de> kirjoitti
> viestissä:aqbtft$gtm$1@news.codecharge.com...
> > Seppo Apajalahti schrieb:
> > > Hi!
> > >
> > > I have problems with dates. I use MySQL and PHP.
> > > I made a form with a date -field. Here in Finland the format is
allways
> > > dd.mm.yyyy. But if I use this or any other format any data will go to
> > > database. There is only 0000-00-00.
> >
> > Hi Seppo,
> >
> > easy thing with this: just go to your project-settings and define the
used
> > date-format in your database (yyyy-mm-dd) and the date-format you want
to
> use in
> > your project (dd.mm.yyyy).
> >
> > Regards,
> > Tobias
> >
>
>
|
|
|
|
|
