This content has been marked as final. Show 5 replies
> // or wherever you put the timezone CFC
> // assuming this is user's locale, you need to manage these
> setLocale("English (Australian)");
not really sure what you're trying to do but maybe something like
> // shortcut method i forgot about
all this seems kind of familiar....
ok i have a date and time column in my database which is put there by the now() function, this is server time.
what i need to do is convert this server time back into my users time.
my users have a column called LocalTime12 which displays the time zones ie Australia/Sydney
so can i use this to change the time back into Australia/Sydney time and date
> so can i use this to change the time back into Australia/Sydney time and date
first, don't do any date math on those datetime objects. after you get them back
from the db,
userTZ="Australia/Sydney"; // or whatever tz ID you need
ok thanks but i am getting a error
Variable DBDATETIMEOBJECT is undefined
> ok thanks but i am getting a error
> Variable DBDATETIMEOBJECT is undefined
place holder, put your real data in there.