Click here to Skip to main content
15,892,298 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: Whaaat??? Pin
Pete O'Hanlon31-May-17 20:09
mvePete O'Hanlon31-May-17 20:09 
GeneralRe: Whaaat??? Pin
OriginalGriff31-May-17 20:49
mveOriginalGriff31-May-17 20:49 
GeneralRe: Whaaat??? Pin
Dominic Burford31-May-17 21:36
professionalDominic Burford31-May-17 21:36 
GeneralRe: Whaaat??? Pin
R. Giskard Reventlov1-Jun-17 4:44
R. Giskard Reventlov1-Jun-17 4:44 
GeneralRe: Whaaat??? Pin
Daniel Pfeffer31-May-17 22:50
professionalDaniel Pfeffer31-May-17 22:50 
GeneralSTAHP USING HIDDEN APIS KTHX Pin
User 483504731-May-17 9:29
User 483504731-May-17 9:29 
GeneralRe: STAHP USING HIDDEN APIS KTHX Pin
raddevus31-May-17 10:14
mvaraddevus31-May-17 10:14 
GeneralToday's Qlikview "You gotta be f*ckin kidding me" moment Pin
#realJSOP31-May-17 8:16
mve#realJSOP31-May-17 8:16 
Dates.

A date is represented as either a floating point value or "datetime". So far so good.

I set the date to 0, and the resulting datetime representation was null. Hmmmm.

I set it to 1, and the datetime was 31 Dec 1899. Well, okay... I guess.

The real adventure starts when you try to find the absolute max datetime that can be represented. There is no documentation that I could find that says what this value is, and I think I know why.

That value is 313740917827896, or 31 Dec 4294967295.

If you add 1 to the numeric value, the represented datetime becomes 01 Jan 0000.

If you continue adding, you can go all the way to 313740918558381, which gives you a datetime of 31 Dec 1999.

If you add 1 to that value, it finally overflows into something that evidently cannot be interpreted as a date.

If you really want a laugh, I changed that absolute max value to a negative number, and I got a datetime of 4294967292 Jan 1900. Yes, that first number is the DAY. Curiously, it's almost the same value as the max possible year (before it wraps around).

I don't know whether to laugh or cry...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013


modified 31-May-17 14:45pm.

GeneralRe: More Qlikview Suckage Pin
OriginalGriff31-May-17 8:22
mveOriginalGriff31-May-17 8:22 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Sander Rossel31-May-17 9:31
professionalSander Rossel31-May-17 9:31 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Deflinek31-May-17 9:39
Deflinek31-May-17 9:39 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Sander Rossel31-May-17 9:41
professionalSander Rossel31-May-17 9:41 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
harold aptroot31-May-17 10:06
harold aptroot31-May-17 10:06 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Sander Rossel31-May-17 10:39
professionalSander Rossel31-May-17 10:39 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Wendelius31-May-17 18:26
mentorWendelius31-May-17 18:26 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Sander Rossel31-May-17 22:42
professionalSander Rossel31-May-17 22:42 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Jörgen Andersson31-May-17 21:51
professionalJörgen Andersson31-May-17 21:51 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Sander Rossel31-May-17 22:41
professionalSander Rossel31-May-17 22:41 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
#realJSOP31-May-17 23:52
mve#realJSOP31-May-17 23:52 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Rick York31-May-17 16:24
mveRick York31-May-17 16:24 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
OriginalGriff31-May-17 10:06
mveOriginalGriff31-May-17 10:06 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Brisingr Aerowing31-May-17 12:52
professionalBrisingr Aerowing31-May-17 12:52 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Mycroft Holmes31-May-17 13:15
professionalMycroft Holmes31-May-17 13:15 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
Jörgen Andersson31-May-17 22:05
professionalJörgen Andersson31-May-17 22:05 
GeneralRe: Today's Qlikview "You gotta be f*ckin kidding me" moment Pin
#realJSOP1-Jun-17 2:00
mve#realJSOP1-Jun-17 2:00 

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.