Special date / time coming up...

map · Mr Calendar Joined: 14 Jun 2004 Karma :

So, soon it'll be the last sequential date (for the UK format dd/mm/yy) of the century.

That'd be today 11/12/13 14:15 hrs (and 16 seconds then).

Very Happy

____________________
...and the whirlwind is in the thorn trees, it's hard for thee to kick against the pricks...
Gibbs, what did Duckie look like when he was younger? Very Happy

Conzar · World Chat Champion Joined: 11 Jun 2012 Karma :

the end is nigh
____________________
Current ride: ZX6R 636 ------- Previous:KTM EXC 450 Supermoto --- ZX6R B1H --Hornet 600--CBR 600--SV650
11:05:35 Rob Fzs: i just wanna own an rd350 valve before they send us to war with durkadurkastan

noobRider · World Chat Champion Joined: 23 Sep 2012 Karma :

See if I can get it as the timestamp Cool

____________________
Licence: Nov 2012, Bikes: Suzuki GN125, Moto Guzzi Strada 750, Triumph Sprint ST 955i x 2
AnPhonEh: I need plans, I need contingency plans also, I need back up contingency plans

G · The Voice of Reason Joined: 02 Feb 2002 Karma :

noobRider · World Chat Champion Joined: 23 Sep 2012 Karma :

G · The Voice of Reason Joined: 02 Feb 2002 Karma :

Spoilt by the '20' at the start, then Smile

.
(Err, as it was in the bit I copied.)

20:02 20/02/2002 was the ultimate, I'd suggest (ignoring seconds) - nothing that palindromic to be repeated with our current system ever.
You could always 20:02:20.02 20/02/2002 if you wanted seconds too Smile

.

benvanwell · Nitrous Nuisance Joined: 10 Apr 2007 Karma :

Does 1/2/34 not count as this century then?
Laughing

____________________
Currently Riding: Triumph Sprint ST 1050
Previous: GSF600s, GS500, BMW F45, CG125

Stowelly · Traffic Copper Joined: 25 Oct 2009 Karma :

G · The Voice of Reason Joined: 02 Feb 2002 Karma :

Surely it will be a mysql datetime format? (May not, of course, but for ease of searching I expect so.)

If we're talking how it's actually stored - should probably be thinking binary Smile

.

Stowelly · Traffic Copper Joined: 25 Oct 2009 Karma :

heh, yeah thats true.... not sure how mysql does dates, but i tend to store most of my stuff as timestamps then convert if necessary, as find it easier to compare timestamps in code!

RhynoCZ · Super Spammer Joined: 09 Mar 2012 Karma :

I'd like to know, what people said when the year 666 was.
____________________
'87 Honda XBR 500, ~~'96 Kawasaki ZX7R P1~~, ~~'90 Honda CB-1~~, ~~'88 Kawasaki GPz550~~, ~~MZ 150 ETZ~~
~~'95 Mercedes-Benz w202 C200 CGI~~, '98 Mercedes-Benz w210 E200 Kompressor

Flatbadger · World Chat Champion Joined: 07 Apr 2012 Karma :

My mile o'meter went to 14000 miles yesterday as well. Alas no £5 was forthcoming.
____________________
If you can keep your head when all about you
Are losing theirs and blaming it on you,
You're in ISIS