Reply to: Who isn't posting on here today?

[TimberWolf]

man time(2)

well until 2037 if you use a 32-bit counter.

You'd be amazed how many permie bozo database "designers" store datetime values in local time, instead of Zulu time or epoch time a-la Dim Prawn, because "we don't have to worry about different time zones".

Ah, no summer time savings to worry about there then, it presumably does the conversion to local time as necessary. That algorithm is going to need updating if we convert to GMT+1 though, or whatever the government proposal is.

Though on reflection, a transaction count would probably serve adequately as a clicky thing in most cases.

[OwlHoot]

Makes sense, but where do you get the "clicks since a fixed epoch" from?

man time(2)

well until 2037 if you use a 32-bit counter.

You'd be amazed how many permie bozo database "designers" store datetime values in local time, instead of Zulu time or epoch time a-la Dim Prawn, because "we don't have to worry about different time zones".

[Moscow Mule]

A man with two watches never knows the right time.

No, but he has got the makings of an excellent duality drive. Just ask threaded.

[TimberWolf]

Multiple clicky things. Need more than 2 though, otherwise you end up with a duality drive...

A man with two watches never knows the right time.

[TimberWolf]

I dunno, it's all drag 'n' drop, 'innit?

You mean use something the O/S provide like timeinMillisecondsSince1970? That would still be date/time dependent though and go screwy when the clocks change? A pure clicky thing that didn't reference data/time would be handy, though if it were independent of data and time conversion to a date/time might be impossible.

[Moscow Mule]

What happens when the clicky thing goes off-line and you lose track of your clicks?

Multiple clicky things. Need more than 2 though, otherwise you end up with a duality drive...

[DimPrawn]

What happens when the clicky thing goes off-line and you lose track of your clicks?

I dunno, it's all drag 'n' drop, 'innit?

[TimberWolf]

A clicky thing that just keeps clicking. Click, click, click.

HTH

What happens when the clicky thing goes off-line and you lose track of your clicks?

[DimPrawn]

Makes sense, but where do you get the "clicks since a fixed epoch" from?

A clicky thing that just keeps clicking. Click, click, click.

HTH

[TimberWolf]

Never store or deal with dates and time as dates and time, always clicks since a fixed epoch.

Only convert them to dates and times for display, applying time zone offsets and daylight saving where applicable.

HTH

Makes sense, but where do you get the "clicks since a fixed epoch" from?

[DimPrawn]

From Wikipedia

In February 2011, the London Stock Exchange finished the switch to Linux. LSE chief executive Xavier Rolet insisted that the exchange, once a monopoly, would deliver record speed and stable trading in order to fight back against the fast erosion of its dominant marketshare by specialist electronic rivals.




OS written by a student in their holidays.

Serves the feckers right. I hope they lose all their trading business and fold. Gates must be pissing himself.

[DimPrawn]

Nice one, does it mean someone fooked up?

On an almost totally unrelated note, I wonder how places that deal with real time (and date) transactions handle the clocks changing, when time repeats itself for an hour each spring.

Never store or deal with dates and time as dates and time, always clicks since a fixed epoch.

Only convert them to dates and times for display, applying time zone offsets and daylight saving where applicable.

HTH

[TimberWolf]

real time data dissemination issue

Nice one, does it mean someone fooked up?

On an almost totally unrelated note, I wonder how places that deal with real time (and date) transactions handle the clocks changing, when time repeats itself for an hour each autumn.

[d000hg]

Can't blame MS this time. Better to fix bugs than put a whole new system together.

[Cliphead]

Thought you'd gone to the pub? Or are you Alex-no-friends sitting at the bar with your iPad 2 posting on here looking like a twat?