What do these timestamp values represent? They look like they might be the number of second of milliseconds between the selected date and some constant date.
This #evaluate(GetEpochTime(createDate(2009,10,31))*1000)# returns this: 1.2569436E+012
This #GetEpochTime(createDate(2009,10,31))# returns this: 1256943600
The second one looks right, but it's not being multiplied by 1000, which needs to happen?
Also, since this app will run on CF 6.1 I was planning on using CFJSON (http://www.epiphantastic.com/cfjson/index.php), since I can't use SerializeJSON()
Has anyone used their CFC?
THe number may be too big for CF... try getting rid of the evaluate
though and just output it.
And I've used that cfjson CFC before. It works well.
I got rid of evaluate() but I'm still getting 1.2569436E+012
Below is the code I'm using:
<cfset EpochDateTimeArray = ArrayNew(1)>
<cfset EpochDateTimeArray[getData.currentRow] = GetEpochTime(createDate(2009,10,31))*1000>
QueryAddColumn(getData, "EpochDateTime", EpochDateTimeArray);
I was going to use CFJSON to encode the "EpochDateTime" column and pass it to the Flot function.
I still have to figure out how to just pass EpochDateTime (instead of the entire dataset).
Does this seem right?