Skip to main content
Daniel_Pride
Daniel_Pride
Known Participant
October 17, 2010
Question

Which Date Format in MySql works with CF and Flashbuilder 4?

  • October 17, 2010
  • 1 reply
  • 2828 views

Which Date Format in MySql works with CF and Flashbuilder 4?

I have been trying to use "Date" but getting the wierdest day before error where the date comes into Flashbuilder properly from MySql via coldfusion and then displays as the day before. It works find on localhost, then when I copy it up to Hostek it gives the day before error.

Should I change the Date format to string or something? is this a known bug?

Thanks

Dan Pride

This topic has been closed for replies.

1 reply

T
tooMuchTrouble
Inspiring
October 17, 2010

On 10/17/2010 3:09 PM, Daniel Pride said:

Which Date Format in MySql works with CF and Flashbuilder 4?

not a string. any one that produces a valid datetime object that cf understands

& that your app can use is fine.

I have been trying to use "Date" but getting the wierdest day before error

where the date comes into Flashbuilder properly from MySql via coldfusion and

then displays as the day before. It works find on localhost, then when I copy

it up to Hostek it gives the day before error. Should I change the Date

format to string or something? is this a known bug? Thanks Dan Pride

if by "flashbuilder" you mean a flex application, probably because client

timezone (tz) vs the server's tz. you'll have to account for any differences

when sending datetimes back & forth as the flash player will always display

datetimes in the client tz.

Daniel_Pride
Daniel_PrideAuthor
Known Participant
October 17, 2010

No, it absolutely is NOT a time zone issue. The date in the dataGrid is the day before in every case (I am only one time zone off anyway and it would not matter, no time is in the field its not date time its just date. see the following example where for many the CF output is correct but the CF output displayed in Flex is one day off.

The following is what Hostek said about it,... but it also is NOT a flashplayer issue cause the same player on my machine shows localhost correctly and hosted wrong.

Feel free to call hostek.com to discuss, or me.

Dan

I just tested this using a MacOS 10.4, Windows XP, Vista, 7, Ubuntu 10.04. Site shows correct date using all of the above, tested using external connection - the date is showing correctly. Yet, trying to pull it up using SkyFire 1.5 browser on WindowsMobile, I am getting the same "one day back" issue that you are seeing.

This really sounds like an issue with the client computer and the way the data is being interpreted localy, not the issue with the server. However, I think we might be able to help you pin point this bug.

If you are able to run this without a problem on your local machine, are you able to change your local DSN - BlueRose to point to "mysql3.ezhostingserver.com" instead of using localhost but run the application from your local machine? This will tell you if the bug might be related to MySQL version.

Another thing to check would be the version of flash player. Computers here that are displaying the page correctly are running 10,1,85,3 (with Ubuntu running 10,0,45,2) and SkyFire that is not displaying the date correctly is running 10,0,32,18.

Please let us know if you need any further assistance.

Alex Y.

T
tooMuchTrouble
Inspiring
October 17, 2010

On 10/17/2010 10:29 PM, Daniel Pride said:

No, it absolutely is NOT a time zone issue. The date in the dataGrid is the

day before in every case (I am only one time zone off anyway and it would not

matter, no time is in the field its not date time its just date. see the

nothing you've said supports that assertion but that your "local" server doesn't

show this behavior screams tz to me (guessing db, db driver, etc are the same as

your production box).

a "Date" in flex is datetime (epoch offset). if your db server's not supplying a

time then its midnight (00:00) on the client. so +/- 1 hr tz difference can

change the "date" on the client.

This really sounds like an issue with the client computer and the way the

data is being interpreted localy, not the issue with the server. However, I

think we might be able to help you pin point this bug.

but that sounds like a tz issue.

to test have your CFC return now() & see what shows up on your client.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices