Click here to Skip to main content
15,904,155 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: It's about TIME for a programming question Pin
Pablo Aliskevicius28-Jul-16 6:44
Pablo Aliskevicius28-Jul-16 6:44 
GeneralRe: It's about TIME for a programming question Pin
Ryan Peden28-Jul-16 6:55
professionalRyan Peden28-Jul-16 6:55 
JokeRe: It's about TIME for a programming question Pin
Nish Nishant28-Jul-16 7:49
sitebuilderNish Nishant28-Jul-16 7:49 
GeneralRe: It's about TIME for a programming question Pin
Marc Clifton28-Jul-16 9:16
mvaMarc Clifton28-Jul-16 9:16 
GeneralRe: It's about TIME for a programming question Pin
Worried Brown Eyes28-Jul-16 11:32
Worried Brown Eyes28-Jul-16 11:32 
GeneralRe: It's about TIME for a programming question Pin
Gaston Verelst28-Jul-16 20:27
Gaston Verelst28-Jul-16 20:27 
GeneralRe: It's about TIME for a programming question Pin
rnbergren29-Jul-16 2:50
rnbergren29-Jul-16 2:50 
GeneralRe: It's about TIME for a programming question Pin
Kirk 1038982129-Jul-16 6:03
Kirk 1038982129-Jul-16 6:03 
This is actually as complicated as you think it is!

Date & Time is location specific (UTC offsets give us that adjustment).
We live in FL and have a place in TN (Central time). While we are there, I
keep my computer in EDT (NY Time) and talk to the clients only as if NY Time.
It is simpler.

Next up. Store all time as UTC type time, collect and display it as "local".
And then the concept of Local to the customer is displayed to the help desk.

As in, it is:
xam in Bangalore (Here)
1pm in NY (Our "Company Standard Time")
4pm in Sacramento, CA (Customer Standard Time)

The magic is that you have to STORE the customer address/UTC offset. And that should
be something you can give them control over.

In Oracle, when a session is created, you can set its default time zone, and dates/times
will adjust (but this get harry over shared web connections), so a lot of our web code just
handled it.

Now with SaaS, you have even more issues, because you add:
?pm in Denver ("Their Company Standard Time, as opposed to ours")

We fought for some time with DB rules that said "Once a record is entered, after midnight, it cannot be changed"). Yep, it was midnight in NY time, and that was 9PM in CA. They were upset in CA. Luckily they were rarely open that late.

BTW, the first part of the conversation (because of all the reminders) is to confirm the time zone with the customer. Because, like myself, they could have traveled elsewhere!

GeneralRe: It's about TIME for a programming question Pin
Steven121829-Jul-16 7:00
professionalSteven121829-Jul-16 7:00 
GeneralRe: It's about TIME for a programming question Pin
Gerry Schmitz30-Jul-16 0:30
mveGerry Schmitz30-Jul-16 0:30 
GeneralRe: It's about TIME for a programming question Pin
H.Brydon30-Jul-16 10:05
professionalH.Brydon30-Jul-16 10:05 
GeneralWhen did you last turn this thing on? Pin
OriginalGriff28-Jul-16 2:42
mveOriginalGriff28-Jul-16 2:42 
GeneralRe: When did you last turn this thing on? Pin
Daniel Pfeffer28-Jul-16 3:03
professionalDaniel Pfeffer28-Jul-16 3:03 
GeneralRe: When did you last turn this thing on? Pin
#realJSOP28-Jul-16 3:44
professional#realJSOP28-Jul-16 3:44 
GeneralRe: When did you last turn this thing on? Pin
dandy7228-Jul-16 4:01
dandy7228-Jul-16 4:01 
General!@#$^%#$(#$@#$#@! Pin
Kornfeld Eliyahu Peter28-Jul-16 2:36
professionalKornfeld Eliyahu Peter28-Jul-16 2:36 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
W Balboos, GHB28-Jul-16 2:40
W Balboos, GHB28-Jul-16 2:40 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
OriginalGriff28-Jul-16 2:43
mveOriginalGriff28-Jul-16 2:43 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
W Balboos, GHB28-Jul-16 2:45
W Balboos, GHB28-Jul-16 2:45 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
Kornfeld Eliyahu Peter28-Jul-16 2:53
professionalKornfeld Eliyahu Peter28-Jul-16 2:53 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
raddevus28-Jul-16 3:49
mvaraddevus28-Jul-16 3:49 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
Kornfeld Eliyahu Peter28-Jul-16 4:17
professionalKornfeld Eliyahu Peter28-Jul-16 4:17 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
Kornfeld Eliyahu Peter28-Jul-16 2:54
professionalKornfeld Eliyahu Peter28-Jul-16 2:54 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
Corporal Agarn28-Jul-16 3:03
professionalCorporal Agarn28-Jul-16 3:03 
GeneralRe: !@#$^%#$(#$@#$#@! Pin
Slacker00728-Jul-16 3:13
professionalSlacker00728-Jul-16 3:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.