CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Strange date problem

Print topic Send  topic

Author Message
michael weaver
Posted: 11/05/2002, 1:07 PM

Hi, I'm storing dates in a mysql database in the following format:
yyyy-mm-dd (ex: 2002-11-05). Everything has been going fine until I just
noticed that when I display the dates as dddd, mmmm d, yyyy (ex: Tuesday,
November 5, 2002) it gives me the wrong day. For instance, for a database
entry for today, it will read 2002-11-05 in the database, but when it
displays it will say Sunday, November 5, 2002 instead of Tuesday November 5,
2002.

Using PHP+templates. Same behaviour on two linux servers. Everything else
seems to be going well.

Anyone have some advice?

michael

michael weaver
Posted: 11/05/2002, 1:59 PM

Sorry - I mis-posted. This was meant for the CCS newsgroup.

m

"michael weaver" <zero@michaelweaver.org> wrote in message
news:aq9bue$rk8$1@news.codecharge.com...
> Hi, I'm storing dates in a mysql database in the following format:
> yyyy-mm-dd (ex: 2002-11-05). Everything has been going fine until I just
> noticed that when I display the dates as dddd, mmmm d, yyyy (ex: Tuesday,
> November 5, 2002) it gives me the wrong day. For instance, for a database
> entry for today, it will read 2002-11-05 in the database, but when it
> displays it will say Sunday, November 5, 2002 instead of Tuesday November
5,
> 2002.
>
> Using PHP+templates. Same behaviour on two linux servers. Everything else
> seems to be going well.
>
> Anyone have some advice?
>
> michael
>
>


   


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.