| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> postgressql sux with documentation
<1> apparently mysql does too since you are here
<0> i just need to find create table syntax
<2> Obrnes : then read the documentation
<3> How do I turn the last column of this to be the same output as the first two columns? -> http://pastebin.com/656462
<4> #mysql
<0> why do u guys even have a channel?
<3> This is being run from ORACLE
<4> To meet chicks, duh.
<5> wow
<3> anyone?
<5> even I didn't get kicked
<1> heh
<1> planet what do you mean the same output?
<1> heh
<3> see how the total says .0340909 what ever I need it to be more human readable like 01:30:25
<1> so do a TO_CHAR(finish - started, 'HH:MI:ss AM') like you do on the other columns
<3> it won't work
<1> what rdbms is this?
<3> I get a ORA-01481: invalid number format model
<3> when I add that CoJoNEsXx
<1> http://www.akadia.com/services/ora_date_time.html
<6> http://tinyurl.com/nvbgb
<7> heh god planet :(
<7> why compare dates like that
<3> CoJoNEsXx - I've already read that doc, it does not provide my answer
<7> planet I ALREADY TOLD YOU THE ANSWER
<7> like 3 hours ago
<3> tenfour - LOL don't you think if your answer actually worked I'd be outta here by now.
<3> dude
<7> you want to get the difference between 2 dates
<7> so use datediff
<5> ooo i got
<5> woo
<7> then you'll get meaningful results
<3> datediff? I tried that
<3> It failed
<7> 2 datetimes subtracted doesnt yield a new datetime
<1> planet it does
<3> how do I use it then?
<1> datediff isnt an oracle function
<7> well then datediff must be broken
<1> planet the article I posted does what you want to do
<8> planet: how did u try to do it?
<7> then it's called something else, but it does have a datediff function
<8> its called datediff
<3> with my SQL*Plus
<8> planet: give me syntax
<3> hold on
<1> datediff is for mssql
<3> FUNCTION DATEDIFF
<3> (
<3> DATEPART VARCHAR2
<3> , DATETIME1 DATE
<3> , DATETIME2 DATE
<3> )
<3> RETURN NUMBER;
<8> http://sybernet.sri.com/oracle/Functions/DATEDIFF.html
<8> CoJoNEsXx: its for oracle also
<1> http://asktom.oracle.com/~tkyte/Misc/DateDiff.html
<6> http://tinyurl.com/c3flq
<1> its not a built in function
<8> planet: i dont wnat ot see what the acutal syntax is.. i want to know how YOU did it
<3> ?? HTTP.DATEDIFF ??
<3> sure
<8> ?
<3> FUNCTION DATEDIFF
<3> (
<3> YYYY-MM-DD HH:MI:ss AM VARCHAR2
<3> , finish DATE
<3> , started DATE
<3> )
<3> RETURN NUMBER;
<7> you done flooding the chan?
<1> planet, read the link http://tinyurl.com/c3flq
<8> planet: you are an idiot
<8> im asking you to show me HOW you are using DATEDIFF
<8> when you claim that datediff isnt owrking for you
<8> how are you using it?
<8> you know.. i say that a lot in here "you are an idiot"
<1> heh
<1> I usually say worse then that
<1> and apparently oracle has a default datediff in new versions
<1> so kudos
<8> o but im not really trying to insult them.. i just really mean what i say
<8> heh
<8> ya i looked it up :)
<8> unlike many other people ASKING TO GET HELP
<1> I think it was introduced in the latest version
<1> but the second link I posted said how to create your own
<8> eh why reinvent the wheel? unless you want a square one :)
<8> actually if you are driving something on logs, its been shown that a square one will perform better than a round one...
<8> food for the thougth here :)
<1> hah
<7> haha
<7> that may be just what planet wants then
<8> lol
<8> a square wheel? :)
<1> bizarro world!
<7> he sounds like a log-road kind of guy
<7> as opposed to a high performance race-track kind of guy
<8> lol
<8> heh he has still yet to post how he was using datediff
<8> :)
<9> yeah, he's done
<9> he's been afk for 20 minutes
<7> but the legend lives on
<9> man, i haven't played that in a _while_
<8> ?
<8> played what
<10> siclude
<8> ya
<8> ?
<10> what's the easiest way to convert a datetime to MM/dd/yyyy HH:mm?
<10> do i need to do 2 converts?
<10> i'm trying to do a group by order by and it wont work unless it's in that format
<8> what rdbms?
<10> sql server
<8> convert
<8> just one should be fine
<8> look up convert
<10> i'm looking at it
<10> nothing does it in that format
<7> why convert it?
<10> i need it grouped by the minute not seconds
<7> group by datepart(
<7> oh nm
<7> wouldn't you want yyyy/MM/dd HH:mm then?
<10> that'll work
<7> otherwise it would sort it in a weird way
<8> i cant find the actual documentation...
<8> but worse comes to worse.. you can always just do a LEFT( on it
<7> datename() can do it for sure
<10> 20 or 120
<10> hmm lemme try that
<8> CONVERT(CHAR(19),GETDATE())
<8> try that
<10> can't order that
<8> y not?
<10> got it
<8> you are supposed to replace the getdate with whtever date you have
<10> cause i'm ordering by the converted datetime
<8> and?
<11> maybe folks that don't understand derived tables will 'get it' with CTEs. Then again, maybe not.
<8> CTE?
<8> thegamble: and where did that come from?
<11> lots of derived table trouble on the channels today
<11> caused a lot of grief for a few people
<7> Grad
<7> try select convert(char(16), getdate(), 126)
<7> that is sortable and only down to the minute
Return to
#sql
or
Go to some related
logs:
#flash
#nhl
#computers
gnaa SUKI
#computers
scalix fetchmailrc
#politics
#beginner
biodiesal, princeton
#nhl
|
|