CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Help with MySQL date storage

Print topic Send  topic

Author Message
Frank Rocco
Posted: 06/06/2002, 7:34 AM

Hello,

What is the best way to store a date entered by a user into a MySQL database
table?
The entry is 5/23/2002 09:30 AM
MySQL does not like the /, and wants to store the date as YYYY-MM-DD

I would appreciate any help.

Thanks

Frank

Frank Rocco
Posted: 06/06/2002, 7:50 AM

Nevermind, I just noticed the DBFormat property.

Thanks

"Frank Rocco" <farocco@hotmail.com> wrote in message
news:adnrtt$ud6$1@news.codecharge.com...
> Hello,
>
> What is the best way to store a date entered by a user into a MySQL
database
> table?
> The entry is 5/23/2002 09:30 AM
> MySQL does not like the /, and wants to store the date as YYYY-MM-DD
>
> I would appreciate any help.
>
> Thanks
>
> Frank
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.