Have you checked the default time zone setting in the database ?




On 8/21/06, gotgoose09 <[EMAIL PROTECTED]> wrote:

In my MySQL table, I have a field that is typed as a Date. In my web
app I send a date from flex to a CFC which populates the Date field.

On my local machine I have MySQL 5 with ColdFusion 7.02.

On my host's server there is MySQL 4 with ColdFusion 7.00.

When I send a date to my MySQL 5, the date is stored as it should be.
When I send a date to MySQL 4, the date is stored a day behind, so I
have to add 1 to the day before sending it to my CFC.

Anyone have experience with the differences between MySQL 4 and 5?


__._,_.___

--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com





SPONSORED LINKS
Software development tool Software development Software development services
Home design software Software development company


YAHOO! GROUPS LINKS




__,_._,___

Reply via email to