I think you should be able to use a .string function and just (one way of doing it) match the positions (in the string) of the time (since it will always be the same -- give your formatting). I pull data from an oracle database. I do it via php though so I have php do the string parsing before it puts it into an xml file. You also have the option of changing the formatting on your database query so that it only returns the time (and not the date) (i.e. hh:mm:ss) brad
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of donvoltz Sent: Saturday, February 23, 2008 10:45 PM To: [email protected] Subject: [flexcoders] Flex Charting with MySQL datetime field Hello Everyone, I have been digging into the flex charting components with nice success. Currently I have extracted a large dataset from a mysql database and would like to plot a line graph with the y-axis being a value and the x-axis being a time. Can anyone point me in the right direction to accomplish this, the time field is returned as an mysql datetime field (ie MM-DD-YYYY hh:mm:ss) and I would like to have the data displayed only as the time since all of the dates are the same Thanks in advance for any direction on this Don
