--- Log opened Tue Feb 21 00:00:00 2012
00:06 -!- sync350 [~sync@c-69-180-10-62.hsd1.ga.comcast.net] has joined #se2600
00:15 <@Catonic> ooh?
00:21 -!- CNwaV [~CNwaV@99-63-224-9.lightspeed.gnvlsc.sbcglobal.net] has joined #se2600
00:21 -!- mode/#se2600 [+o CNwaV] by ChanServ
00:21 <@CNwaV> hey, anyone here run arch?
00:39 <@Evilpig> nope
00:42 <@Evilpig> oh of course IE has to break part of this. http://pigdev/~wilbur/phprackview/phpRackView/rackrequest.php
00:42 <@Evilpig> bah
00:42 <@Evilpig> of course that doesn't work
01:02 -!- RangerZ1 [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has joined #se2600
01:02 -!- RangerZ [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has quit [Ping timeout: 240 seconds]
01:09 -!- ZeroMinuS [~ZeroMinuS@99-63-224-9.lightspeed.gnvlsc.sbcglobal.net] has joined #se2600
01:09 -!- RangerZ [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has joined #se2600
01:09 -!- RangerZ1 [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has quit [Ping timeout: 240 seconds]
01:11 -!- RangerZ1 [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has joined #se2600
01:13 -!- RangerZ [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has quit [Ping timeout: 240 seconds]
01:30 -!- RangerZ1 [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has quit [Read error: Connection reset by peer]
01:49 -!- mog [~mog@fsf/member/mog] has quit [Ping timeout: 240 seconds]
01:58 -!- mog [~mog@c-68-62-170-105.hsd1.al.comcast.net] has joined #se2600
01:58 -!- mog [~mog@c-68-62-170-105.hsd1.al.comcast.net] has quit [Changing host]
01:58 -!- mog [~mog@fsf/member/mog] has joined #se2600
01:58 -!- mode/#se2600 [+o mog] by ChanServ
02:22 <@CNwaV> yeah, you might want an actual domain with a tld
02:34 -!- sync350 [~sync@c-69-180-10-62.hsd1.ga.comcast.net] has quit [Quit: This computer has gone to sleep]
02:39 <@Evilpig> I'm working locally
02:39 <@Evilpig> I forget my devbox isn't tied to the world
02:44 <@CNwaV> y not?
02:44 <@Evilpig> safer that way
02:44 -!- ZeroMinuS [~ZeroMinuS@99-63-224-9.lightspeed.gnvlsc.sbcglobal.net] has quit [Remote host closed the connection]
02:44 <@CNwaV> pigdev.com is an actual domain
02:44 <@Evilpig> I have an external IP on it but you can only hit https on it and even then you'd have to be authenticated
02:44 <@CNwaV> yeah it is
02:44 <@Evilpig> this is my virtualbox dev box.
02:45 <@CNwaV> but, it makes working remotely a pain... why dont you vpn
02:45 <@CNwaV> ah okie
02:45 <@CNwaV> man.... this is gonna take forever... i am trying to move all the info off this box so that i can wipe it and put arch on it
02:46 <@Evilpig> you think that is taking forver...
02:46 <@Evilpig> remember when I got that array in?
02:46 <@Evilpig> the day after that I started a data transfer to it. it's still going
02:46 <@CNwaV> yeah, i can imagine that would take a while....
02:46 <@Evilpig> it would be going much faster if it wasn't reading from that device, then writing back to the same device...
02:47 <@CNwaV> i am just trying to move documents and media off of this... want to get rid of this god forsaken os
02:47 <@Evilpig> which godforsaken os are we talking about?
02:47 <@CNwaV> yeah, scsi or sata?
02:47 <@CNwaV> ubuntu
02:47 <@Evilpig> sata
02:47 <@CNwaV> but it is an older version...
02:47 <@Evilpig> nope. nice and new
02:47 <@CNwaV> for compatability issues with virtualbox
02:48 <@CNwaV> no, i was saying i am running an old version of ubuntu
02:48 <@Evilpig> ohhhh gotcha
02:48 <@CNwaV> 3.0 gbps, or 6.0?
02:48 <@Evilpig> 3. but it isn't getting anywhere near that
02:48 <@Evilpig> i'm seeing a practical copy rate of ~4MB/s
02:49 <@CNwaV> what is causing that?
02:49 <@Evilpig> iowait mostly
02:49 <@Evilpig> I have both of my currently running vms on that array, plus doing a large read and write back to the same array.
02:49 <@CNwaV> did you -w the volumes?
02:50 <@CNwaV> yeah, that will slow things down considerably...
02:50 <@Evilpig> to do the read / write it is reading and writing from a large file. the virtual hard drive file
02:50 <@Evilpig> so yeah i have a perfect storm of shit that will slow it the fuck down
02:50 <@CNwaV> yeah, that is painful
02:50 <@Evilpig> once this 1TB transfer is done I can move shit around and it will be loads faster
02:51 <@CNwaV> so, anyways... ubuntu has become the new windows...
02:51 <@CNwaV> i am giving up and i am going to give arch a spin
02:51 <@Evilpig> heh. I thought that was their goal from the get go?
02:53 <@CNwaV> it is annoying when every version of virtualbox that will work for what i am doing is listed as "depreciated"... and i have to compile from source
02:55 <@Evilpig> heh
02:57 <@Evilpig> damn you dolemite!!!!
02:58 <@Evilpig> I have to fix the html errors before I can fix the css problems and that is completely ignoring the php errors
03:13 <@CNwaV> well that sounds fun...
03:13 <@CNwaV> hey, i might have a new job
03:13 <@Evilpig> cool. doing what?
03:14 <@Evilpig> I might could employ you to hide a body
03:14 <@CNwaV> doing the server side stuff for a company that makes software for radiology labs
03:15 <@CNwaV> i was trying to interview for a tech support position... and they decided that i was interviewing for a network engineer position.../
03:15 <@CNwaV> i just wanted to do tech, wanted my life to be simple.../
03:15 <@CNwaV> but whatever... if they want to double my salary, then i will do it
03:15 <@Evilpig> lol
03:16 <@CNwaV> i have interviewed with 4 people... only 2 to go
03:16 <@CNwaV> but i will have to brush up on my command line stuff
03:17 <@Evilpig> my head hurts. this code is painful.
03:18 <@Evilpig> just realized I introduced a very funny bug
03:18 <@Evilpig> but that will ahve to wait til IE plays nice
03:18 <@CNwaV> hehe, dont get me started on microsoft..
03:19 <@CNwaV> hey have you played with chrome for android yet?
03:19 <@Evilpig> this is me vs my old nemesis. IE layout
03:19 <@Evilpig> nope
03:19 <@Evilpig> I still don't ahve anything running android. ;)
03:19 <@CNwaV> it is pimptastic..
03:19 <@CNwaV> wtf? what kind of phone and tablet do you have?
03:19 <@Evilpig> phone is my pre, still. and tablet is the touchpad. :D
03:20 <@Evilpig> since my pre has a nice little crack int he screen I am seriously looking at the galaxy ii
03:20 <@CNwaV> why dont you have android on your touchpad? you can at least dual boot it
03:20 <@Evilpig> too lazy mostly. it works for what I want as is
03:20 <@CNwaV> i have the galaxy nexus... and i love it
03:21 <@CNwaV> you can do so much more with android..
03:21 <@CNwaV> webos is great for flash.. but there isnt much stuff out there for it
03:21 <@Evilpig> this phone just has a stupidly long name
03:21 <@Evilpig> Samsung Galaxy S™ ll, Epic™ 4G Touch
03:21 <@CNwaV> do yourself a favor and get a 4g verizon phone
03:21 <@Evilpig> I'll be sticking with sprint. much cheaper
03:22 <@CNwaV> if you want something that is solid... then i would get the htc rezound...
03:22 <@CNwaV> verizon is expensive, but they have coverage EVERYWHERE... and the 4g is so fucking fast
03:22 <@CNwaV> you can get a galaxy nexus on sprint
03:23 <@Evilpig> I think my cell phone bill is just under $60 a month after all the taxes and shit. hard to beat that and nashville has great sprint coverage
03:23 <@CNwaV> but seriously, you would love android... you can do pretty much anything with it...
03:23 <@Evilpig> I've been looking at them for a while now. hard to get past that last hurdle of "i'm a cheap fuck"
03:23 <@CNwaV> i can even use my phone or tablets as a remote for my roku... works over wifi
03:25 <@CNwaV> if you want a phone at a good price, buy from wirefly.com...
03:25 <@CNwaV> they are usually $100-$150 cheaper than the actual carrier stores
03:25 <@Evilpig> interesting.
03:26 <@CNwaV> but anyways... verizon 4g is insanely fast... i get 30 mpbs here
03:26 <@Evilpig> hrmm. they are $50 cheaper on that phone than sprint is
03:27 <@Evilpig> that is a nice link. i'll have to hold onto it
03:27 -!- sync350 [~sync@c-69-180-10-62.hsd1.ga.comcast.net] has joined #se2600
03:27 <@CNwaV> there are a few others... amazon mobile even runs some insanely good specials also..
03:27 <@CNwaV> but you have to catch amazon when they have a good sale...
03:28 <@CNwaV> wirefly also has really good sales too... and you can usually get accessories really cheap if you purchase at the same time
03:28 <@Evilpig> neat. i'll watch them and see hwo their sales go
03:28 <@Evilpig> back to code debugging. lord help me
03:29 <@Evilpig> I also need to put this bag of "Bumpy jelly beans" away beforeI make myself sick.
03:29 <@Evilpig> nerds + jelly beans = tasty and weird as fuck
03:29 <@CNwaV> the verizon galaxy nexus is $200 cheaper on wirefly compared to verizonwireless.com
03:29 <@Evilpig> http://www.wirefly.com/eCommerce/SpecialOffer.aspx?cid=21427_004499b944c94aa986db36825f1d0b2f
03:29 <@CNwaV> bumpy jelly beans? that has piqued my interest
03:30 <@Evilpig> found them at kroger yesterday morning in the easter shit
03:30 <@Evilpig> http://www.facebook.com/WonkaNerdsBumpyJellyBeans
03:30 <@Evilpig> and apparently they have a facebook page
03:31 <@CNwaV> i would honestly get a phone that doesnt have the capacitive or physical buttons...
03:31 <@CNwaV> i gotta go grab some..
03:31 <@CNwaV> hey, i watched that movie you told me about...
03:31 <@Evilpig> I like actual buttons. I hate that my pre requires you to use the damned screen
03:31 <@Evilpig> which one?
03:32 <@CNwaV> http://www.wirefly.com/eCommerce/SpecialOffer.aspx?cid=21427_ecb0cfd4d47c4b15b6d7f2371554a774
03:32 <@CNwaV> the wild and wonderful whites of west virginia
03:32 <@Evilpig> that one was a trip!
03:32 <@CNwaV> hehe, yeah
03:33 <@CNwaV> how many people are you expecting for geeknic?
03:33 <@Evilpig> i'll ask dolemite in the morning
03:33 <@Evilpig> i've been somewhat detached from that cause of other projects.
03:33 * CNwaV stabs Dagmar in the fucking face
03:41 <@Evilpig> damn ie. damn you to hell, along with dolemite
03:43 <@CNwaV> ie is awesome sauce...
03:43 <@CNwaV> i cant wait till they port it ;)
03:43 <@Evilpig> i've got a div in IE that is just wanting to be width 100% for no damn good reason
03:45 <@Evilpig> might have found it
04:09 <@CNwaV> btw, Evilpig, you can still get unlimited data on new lines for verizon if you know what you are doing
04:09 <@Evilpig> not too worried about that.
04:09 <@Evilpig> me and IE are about to throw down
04:14 <@CNwaV> punch that dirty whore in the face
04:16 <@Evilpig> why is it sometimes the most stupidly simple thing makes it work?
04:22 <@CNwaV> *insert comment about MS products*...
04:22 <@CNwaV> and, yes, i am a hater
04:23 <@CNwaV> bbl, gonna shut down... maybe get some sleep... gotta see some customers tomorrow and maybe have an interview..
04:23 -!- CNwaV [~CNwaV@99-63-224-9.lightspeed.gnvlsc.sbcglobal.net] has quit [Quit: Leaving]
04:32 -!- sasquatc3 [~none@c-71-229-186-129.hsd1.co.comcast.net] has quit [Read error: Connection reset by peer]
04:33 -!- sasquatc3 [~none@c-71-229-186-129.hsd1.co.comcast.net] has joined #se2600
04:33 -!- mode/#se2600 [+o sasquatc3] by ChanServ
05:42 <@Evilpig> ARGFGGGGGGGGGGGGGGGGGGG!!!!
05:42 <@Evilpig> WTF?!?!
05:42 <@Evilpig> okay how can I view a page on the server and the layout is fucked. but if I save the page and view it locally it is fine?
05:44 <@Evilpig> what if IE is trying to render the page as it is fed each line instead of as a whole because of how the code was written?
05:45 <@Evilpig> easy enough to test
06:48 <@Evilpig>
06:48 <@Evilpig> ^--- THAT! That is the answer
06:48 <@Evilpig> fucking IE
07:21 <@Bahhumbug> Why do you bother? js a browser ident at initial page load, cry if it's ie and refuse to work and make people upgrade to something that's not a piece of shit.
07:53 -!- sync350 [~sync@c-69-180-10-62.hsd1.ga.comcast.net] has quit [Quit: This computer has gone to sleep]
07:58 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has joined #se2600
08:10 <@Dickie> Set your own policies!
08:29 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has quit [Quit: Leaving.]
08:41 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has joined #se2600
08:52 -!- phaile [~phaile@mail.cfmt.org] has joined #se2600
08:55 -!- phaile [~phaile@mail.cfmt.org] has left #se2600 []
09:37 -!- m0j0-j0j0 [~jkemp@cnet520-hosoc.mcclatchyinteractive.com] has joined #se2600
10:21 <@Bahhumbug> http://ow.ly/i/t8bb
10:22 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has quit [Quit: Leaving.]
10:32 <@Dagmar> I probably just started a firestorm on Google+.
10:32 <@Dagmar> Oh well. LOL.
10:32 <@Dagmar> I AM TIRED OF SEEING FAT CHICKS COMPLAIN.
10:32 < timoguin> you!? a firestorm!?
10:32 < timoguin> surely not
10:33 <@Dagmar> Seriously how many times do we have to see these bullshit pictures about "the unreasonable standards" for women's weight and not say anything
10:34 <@Dagmar> They'll show a skinny chick in her underwear, then an average chick, and a "heavy" chick, all three in great shape.
10:34 < timoguin> and they all look great
10:34 <@Dagmar> ...whining about how the third isn't considered "attractive" because of her weight.
10:34 <@Dagmar> It's a load of crap.
10:35 <@Dagmar> They *are* all attractive because they're in freaking shape.
10:35 < timoguin> they should make one with an obese girl as the fourth
10:35 <@Dagmar> If you weight 210lbs and look that way, great. You're actually attractive.
10:35 <@Dagmar> The rest of the women weighing 210lbs out there are just fucking _FAT_ because they're not in shape, and that's not attractive.
10:36 <@Dagmar> They should stop sitting around the house whining on the computer and mabe jog a bit
10:36 <@Dagmar> ...and they hold men up to the same bullshit standards.
10:36 <@Dagmar> I'm tired of seeing this illogical crap on blogscroll.
10:37 <@Dagmar> "Pear shaped" is not an attractive shape.
10:38 <@Bahhumbug> It is if you're a pear.
10:38 <@Bahhumbug> Or really like pears.
10:38 <@Dickie> one who pees
10:38 <@Dickie> oh, pear
10:38 <@Dickie> read "peer"
10:38 <@Dickie> Shut the fuck up, Dickie.
10:38 <@Bahhumbug> heh
10:39 < timoguin> i love pears
10:46 -!- sasquatc3 is now known as sasquatc4
10:59 -!- brimstone [~brimstone@unaffiliated/brimstone] has quit [Disconnected by services]
10:59 -!- brimston3 [~brimstone@2001:470:1f10:1083::2] has joined #se2600
11:00 -!- scribbles [s@addictedto.info] has quit [Changing host]
11:00 -!- scribbles [s@unaffiliated/scribbles] has joined #se2600
11:00 -!- CNwaV [~yaaic@99-63-224-9.lightspeed.gnvlsc.sbcglobal.net] has joined #se2600
11:00 -!- mode/#se2600 [+o CNwaV] by ChanServ
11:14 -!- brimston3 is now known as brimstone
11:14 -!- brimstone [~brimstone@2001:470:1f10:1083::2] has quit [Changing host]
11:14 -!- brimstone [~brimstone@unaffiliated/brimstone] has joined #se2600
11:14 -!- mode/#se2600 [+o brimstone] by ChanServ
11:41 -!- iabosi [~iabosi@centauri.iabosi.com] has joined #se2600
11:52 -!- jb7od_ [~mfph@gateway/tor-sasl/jb7od] has joined #se2600
11:52 -!- mode/#se2600 [+o jb7od_] by ChanServ
11:56 <@jb7od_> jjjjJJJJJJetson!!
11:59 <@CNwaV> No
11:59 < iabosi> \part
11:59 < iabosi> OOPS
11:59 -!- iabosi [~iabosi@centauri.iabosi.com] has left #se2600 []
12:36 -!- Catonic [~catonic@adsl-98-83-206-105.bhm.bellsouth.net] has quit [Ping timeout: 252 seconds]
12:48 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has joined #se2600
12:56 -!- CNwaV [~yaaic@99-63-224-9.lightspeed.gnvlsc.sbcglobal.net] has quit [Ping timeout: 265 seconds]
13:10 -!- CNwaV [~yaaic@35.sub-174-254-119.myvzw.com] has joined #se2600
13:29 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has quit [Quit: Leaving.]
13:37 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has joined #se2600
13:41 -!- timoguin [~toguin@173-162-19-241-Nashville.hfc.comcastbusiness.net] has quit [Ping timeout: 245 seconds]
13:41 -!- timoguin_ [~toguin@173-162-19-241-Nashville.hfc.comcastbusiness.net] has joined #se2600
14:12 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has quit [Quit: Leaving.]
14:12 -!- timoguin_ is now known as timoguin
14:13 -!- mode/#se2600 [+o timoguin] by ChanServ
14:42 -!- Catonic [~catonic@adsl-98-83-42-138.bhm.bellsouth.net] has joined #se2600
14:42 -!- mode/#se2600 [+o Catonic] by ChanServ
15:02 -!- CNwaV [~yaaic@35.sub-174-254-119.myvzw.com] has quit [Ping timeout: 245 seconds]
16:18 -!- Vyrus [~Vyrus001@209.159.137.115] has quit [Ping timeout: 260 seconds]
16:39 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has joined #se2600
17:11 -!- stowbari [~Stowbari@adsl-69-208-4-181.dsl.akrnoh.ameritech.net] has quit [Quit: Leaving.]
17:15 -!- CNwaV [~yaaic@209.sub-174-252-185.myvzw.com] has joined #se2600
17:15 -!- mode/#se2600 [+o CNwaV] by ChanServ
17:32 -!- Catonic [~catonic@adsl-98-83-42-138.bhm.bellsouth.net] has quit [Read error: Connection reset by peer]
19:18 -!- RangerZ [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has joined #se2600
19:34 <@Evilpig> Dagmar: call the noc when you get a chance please.
19:38 <@Dagmar> Any particular reason?
19:40 -!- CNwaV [~yaaic@209.sub-174-252-185.myvzw.com] has quit [Ping timeout: 260 seconds]
19:41 -!- Catonic [~catonic@adsl-98-83-160-222.bhm.bellsouth.net] has joined #se2600
19:41 -!- mode/#se2600 [+o Catonic] by ChanServ
19:42 -!- CNwaV [~yaaic@68-189-190-128.dhcp.spbg.sc.charter.com] has joined #se2600
19:42 -!- mode/#se2600 [+o CNwaV] by ChanServ
19:46 < RangerZ> he misses your voice
20:05 -!- Vyrus001 [~Vyrus001@209.159.137.115] has joined #se2600
20:35 -!- sync350 [~sync@c-24-30-78-161.hsd1.ga.comcast.net] has joined #se2600
20:59 <@Dagmar> Damn what's the magic secret about comparing date fields in SQL
21:01 <@Dagmar> I'd also like to know how the hell an item showing as DATE in the output of describe magically gets a meaningful hour figure on it when you format it that way
21:01 <@Dagmar> I was under the impresion that DATE was yyyy-mm-dd only
21:03 < RangerZ> Dagmar: LOL, nope
21:03 <@Dagmar> Fuck
21:03 < RangerZ> if it is a PHP date put into a string field
21:03 <@Dagmar> Why the hell does everything I see on the web show that
21:03 < RangerZ> b/c they re-encode it
21:03 <@Dagmar> I'm not talking about a PHP date
21:04 < RangerZ> http://www.tizag.com/sqlTutorial/sqldate.php
21:04 -!- sync350 [~sync@c-24-30-78-161.hsd1.ga.comcast.net] has quit [Quit: This computer has gone to sleep]
21:04 < RangerZ> 2 different versions for the SQL date: date and datetime
21:04 <@Dagmar> I mean doing an sql query against it using YYYY-MM-DD HH24:MI as the format string seemed to magically have hours and minutes
21:05 <@Dagmar> Rangerz: Yes, and as I understood it, `describe tablename;` doesn't lie
21:05 <@Dagmar> From the output of describe, this item is supposed to be a DATE field
21:05 < RangerZ> ohh yee of little -lack of faith- in oracle
21:05 <@Dagmar> ...except I could use BETWEEN on them for some fucking reason
21:05 < RangerZ> lol
21:05 < RangerZ> hold on
21:06 <@Dagmar> Do they seriously have this shit in there and it doesn;t know how to compare something to see if it's between two dates?
21:06 <@Dagmar> ...and yet this fucking code was doing some weird to_blah shit using >=
21:06 <@Dagmar> er could NOT use BETWEEN on them
21:06 <@Dagmar> It didn't work
21:07 <@Dagmar> I'd run the query with the insane looking SQL that was being used, got a result
21:07 <@Dagmar> Rewrote it to not do so many fucking data conversions... 0
21:07 < eryc> heh
21:07 < eryc> to_unixtime?
21:07 < eryc> mysql or oracle?
21:08 <@Dagmar> No it was like to_conv or somethign I can't remember
21:08 < eryc> oh i guess thats not a valid question anymore :(
21:08 -!- phaile__ [~mfph@gateway/tor-sasl/jb7od] has joined #se2600
21:08 -!- mode/#se2600 [+o phaile__] by ChanServ
21:08 <@Dagmar> It was being used like sprintf
21:08 < eryc> weird
21:08 < eryc> tz change maybe?
21:08 <@Dagmar> Actually, that's part of the problem
21:09 <@Dagmar> I'll show you in a moment
21:09 < RangerZ> ahh, thats what i was remembering, but couldn't get completely strait, oracle and mysql store their dates different
21:09 < RangerZ> dd-mon-yyy for oracle, yyyy-mm-dd for mysql
21:09 -!- jb7od_ [~mfph@gateway/tor-sasl/jb7od] has quit [Remote host closed the connection]
21:10 <@Dagmar> Yeah but either way there's no fuckin' TIME in that
21:10 < RangerZ> http://www.databasejournal.com/features/mssql/article.php/10894_2209321_2/Working-with-SQL-Server-DateTime-Variables-Part-Three---Searching-for-Particular-Date-Values-and-Ranges.htm
21:10 < RangerZ> that is a "DATETIME"
21:10 < RangerZ> which is different from "DATE"
21:11 < RangerZ> but one of the "DATE" types
21:11 <@Dagmar> I kow.
21:11 <@Dagmar> er know
21:11 <@Dagmar> This is the insane-o code:
21:11 <@Dagmar> select count(to_char(eventtime,'MM/DD/YYYY HH24')) from incadmin.auditlog
21:11 <@Dagmar> where to_char(eventtime,'MM/DD/YYYY HH24')>=TO_char(sysdate+4/24, 'MM/DD/YYYY HH24')
21:11 <@Dagmar> and to_char(eventtime,'MM/DD/YYYY HH24')<=TO_char(sysdate+5/24, 'MM/DD/YYYY HH24');
21:11 <@Dagmar> According to the output of describe, eventtime is _just_ a date
21:12 <@Dagmar> So I'm like, how the fuck does this even *work*
21:12 < RangerZ> ahh, it is using "to_char" function trickery
21:12 <@Dagmar> WTF good does that even do?
21:12 <@Dagmar> It seems like every bit of this code is hellishly wrong
21:13 <@Dagmar> ....but it works anyway just to piss me off
21:13 < RangerZ> take out the " HH24" from both
21:13 <@Dagmar> No, you don't seem to be listening.
21:13 <@Dagmar> The code _works_
21:13 <@Dagmar> This is what's got me going WTF
21:13 < RangerZ> why?, it is clear what it is doing
21:14 <@Dagmar> Where is the _hour_ coming from?
21:14 < RangerZ> "HH 24"
21:14 <@Dagmar> Why the fuck isn't this just being done as select count(id) from incadmin.auditlog where eventtime between '$onetime' and '$someothertime';
21:15 <@Dagmar> Rangerz: So, eventtime is the DATE item
21:15 <@Dagmar> It has no time component that I'm aware of
21:16 < eryc> so is this mssql, mysql, or oracle?
21:16 < RangerZ> it would be thrown away...ish
21:16 <@Dagmar> eryc: Pretty sure it's Oracle
21:16 < RangerZ> yeah
21:16 < RangerZ> the to_char is oracle
21:16 < eryc> so i think sqlplus may not show the time by default
21:16 <@Dagmar> See, I don't understand why the fuck they'd use that
21:16 < eryc> or perhaps oracle rather
21:17 <@Dagmar> eryc: sqlplus is the client I was using
21:17 < eryc> i think its hiding
21:17 <@Dagmar> I think maybe the entire thing is lying about the data type
21:17 < eryc> i think it hides the time component by default
21:17 <@Dagmar> Well, it doesn't output it by defaullt that much is true
21:17 < RangerZ> if nothing else... it is silly to count() where..... instead of just counting that entire "where clause"
21:17 < eryc> i don't know why but its like a vague memory
21:17 <@Dagmar> ...but as I understand it, if you have a DATE field you shouldn't be able to store time in it as well
21:18 < eryc> well a date would be a rounded off time in that case
21:18 <@Dagmar> Rangerz: Well, I was reasonable sure about changing it to just count(id)
21:18 < eryc> rounded down to midnight
21:18 <@Dagmar> I don't see *any* point in doing data conversion on some shit we're just going to count
21:18 < RangerZ> yeah
21:18 < RangerZ> there isn't
21:18 <@Dagmar> eryc: Yeah see if it did shit like that I'd understand, but...
21:19 < RangerZ> dagmar... the ONLY reason you would do it... is if your SQL tables are FUBAR
21:19 <@Dagmar> When I did select to_char(eventtime, 'YYYY-MM-DD HH24:MI') I got minutes and seconds
21:19 <@Dagmar> er hours and minutes
21:19 < RangerZ> and have IDs that don't have dates
21:19 <@Dagmar> They were just really obviously midnight
21:19 <@Dagmar> er were NOT
21:20 <@Dagmar> RangerZ: well, also if you're just copypastaing things out of ritual
21:20 < eryc> Dagmar: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html
21:21 < eryc> Oracle supports both date and time, albeit differently from the SQL2 standard. Rather than using two separate entities, date and time, Oracle only uses one, DATE. The DATE type is stored in a special internal format that includes not just the month, day, and year, but also
21:21 < eryc> the hour, minute, and second.
21:21 <@Dagmar> Am I mistaken or should a simple select blah where eventtype between '0000-00-00 14:00' and '0000-00-00 16:00' should have worked?
21:21 <@Dagmar> eryc: OKay, THANK YOU
21:21 <@Dagmar> I thought I was losing my fucking mind
21:21 <@Dagmar> ...or that something was seriously tampering with the results
21:22 < eryc> funny enough its the 2nd hit on google for "oracle date"
21:22 <@Dagmar> I mean I really thought the point of using a _relational_ database was so we could ask it things that require it to understand some shit about data, like between two timespecs
21:22 <@Dagmar> Fuck
21:23 <@Evilpig> is that the correct time format? cause different DBs store it funny and how you have to ask changes too. that's the only question i'd have
21:23 <@Dagmar> I was doing 'sql date format' 'sql date comparisons' 'sql date conversions' and never saw that
21:23 <@Bahhumbug> oracle sucks
21:23 <@Evilpig> otherwise yeah it should have
21:23 <@Bahhumbug> just sayin'
21:23 <@Dagmar> "between" should work on DATE types tho right?
21:23 <@Dagmar> Do I have to do anything fancy to the 'YYYY-MM-DD 14:00' beyond just putting it in single quotes?
21:24 <@Evilpig> it should. but I think last time I did one like that I had to do something goofy like FROM XXXX to XXXX
21:24 <@Dagmar> Evilpig: This is directly related to me trying to refactor that fucked up alarm
21:24 <@Evilpig> or WHERE Date < XXXXXX and Date is > XXXXXX
21:25 <@Evilpig> it was that last one actually
21:25 <@Dagmar> Yeah see that to me sounds like I'm asking the server to do things ni a sub-optimal way
21:25 <@Evilpig> because between never worked right.
21:25 <@Bahhumbug> It's oracle, there is nothing "optimal" about oracle.
21:25 <@Dagmar> The last time I did this shit it was before Perl had stored procs and stuff so we had a library we just ran shit *through*
21:26 <@Dagmar> hateful. http://www.w3schools.com/sql/sql_between.asp says it should have worked too
21:26 -!- sync350 [~sync@c-24-30-78-161.hsd1.ga.comcast.net] has joined #se2600
21:26 <@Dagmar> Maybe I was just freaked out and overlooking something major
21:27 <@Evilpig> between shoudl work. but like I said last time I messed witha sql date query I ended up with the two cases
21:30 < eryc> http://stackoverflow.com/questions/2369222/oracle-date-between-query
21:32 < eryc> when dealing with oracle its best to include "oracle" as the first search term
21:32 < eryc> because pl/sql is not really sql
21:32 < eryc> imo
21:35 < RangerZ> truth @ eryc
21:36 <@Dagmar> I actually think I understand what was going on now. Just a minute while I deal with the rest of laundry
21:37 <@Bahhumbug> What was going on was you were trying to apply logic to that which is without logic.
21:39 < RangerZ> Dagmar: http://9gag.com/gag/2810769
21:39 < RangerZ> you should be able to make it work with your Xoom
21:39 <@Dagmar> IN THE BEGINNING...
21:39 <@Dagmar> Oracle said, "let there be DATE" and there was DATE.
21:40 <@Dagmar> Then Oracle said, "Let there be TIME!" and there was time.
21:40 <@Dagmar> ...and then someone else said "It's so simple really, there should be a DATETIME combination type" and Oracle said "Fuck you, write a two component query, but we'll at least store them for you."
21:41 <@Bahhumbug> [21:23:04] <@Bahhumbug> oracle sucks
21:41 <@Dagmar> BETWEEN was fucking me over because with Oracle saying "Fuck your fancy data type" it was *only* comparing the date part and ignoring the time part.
21:41 <@Dagmar> Since I am not an idiot, I don't use dumbass queries against contiguous ranges where <= and >= both get used.
21:42 <@Dagmar> I use > on one side and <= on the other.
21:42 <@Dagmar> THis will always produce an empty set.
21:42 <@Dagmar> The DBA, seeing Oracle's hateful behaviour, uses to_char to force the damn thing to deal with the time as well as the date
21:43 <@Dagmar> ...and then she throws it into the count() function as hateful sarcasm.
21:43 <@Dagmar> RangerZ: I may have already seen one at Bongo Java
21:44 <@Dagmar> I can't think of any other reason a freshman would have been toting around a manual typewriter
21:45 <@Dagmar> eryc: That clue you found was what I needed to figure out WTF I was seeing this afternoon
21:45 <@Dagmar> Thanks muchly
21:46 <@Dagmar> I knew Julie couldn't have been insane.
21:46 <@Dagmar> BT storing a datetime in a time field tho? I can _totally_ see that.
21:46 <@Dagmar> er s/time/date/
21:46 <@Dagmar> BT is fucking retarded like that
21:57 < eryc> np
23:23 -!- RangerZ [~mwalker@c-98-211-44-193.hsd1.tn.comcast.net] has quit [Read error: Connection reset by peer]
23:51 -!- peaches1984lap [four@c-69-137-80-31.hsd1.tn.comcast.net] has joined #se2600
23:52 -!- peaches1984lap [four@c-69-137-80-31.hsd1.tn.comcast.net] has left #se2600 []
--- Log closed Wed Feb 22 00:00:00 2012