Skip to main content
S
Simon.Dau
Known Participant
November 4, 2010
Question

Timezone question

  • November 4, 2010
  • 2 replies
  • 553 views

Hey guys,

So this time I ran into following issue:

my server is somewhere in states and meself - england. So my date fields in database gets all messed up. Date entries under timestamp format shows correct time (UK), but fields which gets now() time are set to a -7 hours difference.

Question: is there any way to set an application timezone in application.cfc file?

cheers,

Simon

    This topic has been closed for replies.

    2 replies

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    November 6, 2010

    Simon.Dau wrote:

    my server is somewhere in states and meself - england. So my date fields in database gets all messed up. Date entries under timestamp format shows correct time (UK), but fields which gets now() time are set to a -7 hours difference.

    Question: is there any way to set an application timezone in application.cfc file?

    Yes. Save all datetime values in the locale and in the format  that you yourself deem correct.

    T
    tooMuchTrouble
    Inspiring
    November 5, 2010

    On 11/5/2010 3:59 AM, Simon.Dau said:

    Question: is there any way to set an application timezone in application.cfc file?

    no. but you can handle different timezones(tz) in cf. first read this for some

    background & gotchas:

    http://bit.ly/b4VJsN

    then have a look at this component:

    http://www.sustainablegis.com/projects/tz/testTZCFC.cfm

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices