| |
| |
| |
|
Page: 1 2
Comments:
<0> join #mysqlphp or #phpmysql
<1> ok
<1> 10x
<2> ten times what?
<3> is anyone here good with the configs for mysql.
<3> http://pastebin.com/519676
<4> is anyone here... available?
<5> cool
<3> anyone have idea's
<2> [kristianf@localhost ~]$ gpg --version | grep IDEA
<2> Cipher: IDEA, 3DES, CAST5, BLOWFISH, AES, AES192, AES256, TWOFISH
<5> heh
<5> diggle, what was your question?
<2> I'm sure I can answer 42
<6> The answer is... 42!
<7> hey K_F, you know everything - why this no work: SELECT FROM_UNIXTIME(MAX(file_date)) AS foo FROM `search` |file date is a timestamp
<2> a TIMESTAMP field?
<2> the TIMESTAMP field isn't UNIX_TIMESTAMP
<2> it is a DATETIME with certain features
<2> sure you don't want UNIX_TIMESTAMP() +
<7> UNIX_TIMESTAMP returns "0" FROM_UNIXTIME returns "null"
<2> and MAX(file_date) ?
<7> 4294967295
<7> i alwyas confuse these datestamp timestamp unix stap date time things
<7> 4294967295 thats a unix time stamp correct?
<2> probably too high value
<2> 2037
<2> actually, 2038-01-01
<2> is the highest value you can have
<2> | UNIX_TIMESTAMP('2038-01-01') |
<2> +------------------------------+
<2> | 2145913200 |
<7> odd, ill go see wherre thats surced from
<2> signed 32bit
<2> you have an unsigned 32 bit
<2> long story short it is out of bounds
<7> yeah i buggered the insert, ill go fix that
Return to
#mysql
or
Go to some related
logs:
cant find mlnet
ReDragon buffer Overflow
#chatzone
Jh0n-t
12WHAT IS THE LARGEST SCANDINAVIAN COUNTRY?
paagles
#mirc
#linux
russepresidentstripping jpg
#linux
|
|