You know you're a geek when........

[Metallion]

You know you're a geek when you waste your lots of time in a single problem

Guilty as charged. If only mysql's freaking TIME format wasn't limited to 838 hours >.<#.

[pqwoerituytrueiwoq]

when you use a unix time stamps for dates in your sql database
i store them as GMT 0 and use php to process them for the appropriate time zone

[Metallion]

when you use a unix time stamps for dates in your sql database
i store them as GMT 0 and use php to process them for the appropriate time zone

Thanks. That's indeed the solution I came up with as well after reading a bunch more documentation. I use unix timestamps in my query and store Wakame-VDC's ip address retention period as an unsigned int representing seconds. That'll probably work. *Desperately tries not to remember what happened all the other times he said that last sentence while programming.*

[pqwoerituytrueiwoq]

when you can convert times stamps to human time in sql

the only annoying part is when you try to read the dates in phpmyadmin

[Metallion]

That won't be a problem since Wakame is written in Ruby and we use our own custom cli to handle database operations by hand. Automatic ones are done with the Sequel library. Cool stuff that is. Lets you treat your database entries as objects of a class with its own methods and such.

You know you're a geek when you go off topic to talk about programming.

[lisati]

when you use a unix time stamps for dates in your sql database

.... and choosing between 32-bit and 64-bit representation is close to a no-brainer.

[tlhIngan]

Seriously...

nad@Nad:~$ man woman
No manual entry for woman
nad@Nad:~$

Ha! Didn't know that one!

[tlhIngan]

...when you know why Ubuntu started at version 4.10 instead of 1.0 like everybody else.

[pqwoerituytrueiwoq]

when you install from the mini.iso

[tlhIngan]

...when you own a copy of every single album "Weird Al" Yankovik has ever put out.