This should do it--obviously if you use this a lot you'd want to turn
it into a function so you can reuse it wherever you need it (let me
know if you need help with that).
<cfscript>
sdf = CreateObject("java",
"java.text.SimpleDateFormat").init("yyyy-MMM-dd HH:mm:ss");
sdf.setTimeZone(CreateObject("java",
"java.util.TimeZone").getTimeZone("GMT"));
sdfLocal = CreateObject("java",
"java.text.SimpleDateFormat").init("yyyy-MMM-dd HH:mm:ss");
WriteOutput(sdfLocal.parse(sdf.format("2011-04-05 17:59:59")));
</cfscript>
The WriteOutput at the end is just so you can see the result. The meat
of it is sdfLocal.parse(sdf.format(YOUR_DATE_STRING_HERE)) which you
can set to a variable if you need to:
myUTCDate = sdfLocal.parse(sdf.format("2011-04-05 17:59:59"));
Let me know if you need further help on this, and thanks for bringing
the bug to our attention. I suspect it'll be a quick fix once we get a
chance to look at the code since on the face of it it just seems like
a one-off/wrapping type error.
--
Matthew Woodward
[email protected]
http://blog.mattwoodward.com
identi.ca / Twitter: @mpwoodward
Please do not send me proprietary file formats such as Word,
PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
--
official tag/function reference: http://openbd.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
