Thanks, Paul! I guess I was totally mis-interpreting what the
actual problem was. I don't know why I had that CreateODBCDateTime
in there... I copied that code out of my scratch file and was
messing around with trying to make sure the timezone info was there.
Thanks for the assist.
That does the trick.
Jon
On May 2, 2007, at 3:03 PM, Paul Hastings wrote:
> Jon Clausen wrote:
>> <cfset date = dateAdd("d",-1, now())>
>> <cfset date = createODBCDateTime(date)>
>
> you don't need this step.
>
>> <cfset udate = date.getTime()>
>
> that gives java epoch, *milliseconds* since 1-jan-1970.
>
>> through digging around in java docs. Instead I need to pass a 32-
>> bit timestamp.
>
> unix epoch is *seconds* since 1-jan-1970. either divide the java
> epoch by 1000
> or simply do a dateDiff() from 1-jan-1970 using second date parts.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
