On 4/9/2012 2:40 AM, Gonzo Rock wrote:
> Then using
> <cfset theDate = CreateODBCDateTime(RightNow)>
the value returned from now() should be ok to insert into DB, no need for this
step.
> Going through all the time and time zone settings on the linux box all
> seems right.
db & cf on same server? whats the tz for the server?
whats the tz for postgres (i *think* thats set via conf)?
SELECT current_setting('TIMEZONE')
tz for the JVM cf's running under?
tz=createObject("java","java.util.TimeZone").getDefault();
tzName=tz.getDisplayName(true,tz.LONG);
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350662
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
