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 -> GotoCode Archive

 CCS: DATE format in MySQL (PHP4+templates)

Print topic Send  topic

Author Message
Labs4.com
Posted: 11/10/2002, 4:02 PM

This is not a question, just short explanation to people who have met with this problem.

Be sure that you are using DATETIME data type in MySQL databases for all date related stuff because if you should use DATE, PHP class will not recognize it and will refuse to work with it.

Just wanted to let you know, because I just spent two hours with debugging and finally found the problem.
Steve Chevalier
Posted: 11/11/2002, 2:54 PM

I have a mySQL database with several tables that have date fields. The mySQL field type is "DATE" and I have had good luck with them using CodeCharge and PHP. There is even a nice little datepicker addin tool. I struggled at first but once I got the format correct "YYYY-MM-DD" things went fairly well.

   


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.