Search results for query: *

Morning/Afternoon all... Can some one tell me how i can age records, I have 4 years worth of data which needs to be flagged into 4 categories: 3-6 mths 6-12 mths >12 mths old. I then need to apply a set of rules to the above. Thought i could use something like (MONTH(traffic_month) =...

Hi Does anyone know how i can select a substr() of a timestamp field...? The data within the field is stored as 12-JUL-04 10.00.36.000000 AM and i need to pull out certain records within a particular time period. Thanks for any help provided. N

Hi could someone help me with trying to determine the duration in seconds between 2 dates...? This is what i'm trying to do : select START, RELEASE, (TO_DATE( SUBSTR(RELEASE, 1, length(RELEASE) - 4), 'YYYY-MM-DD HH24:MI:SS'))- (TO_DATE( SUBSTR(START, 1, length(START) - 4), 'YYYY-MM-DD...

Actually Just looking at the results it appears that only the date is being pulled back and that the time part is being ignored...? Any ideas? Thanks N

That works fine...! Thanks very much. N

Hi everyone I'm not much of an Oracle person however i would appreciate it if someone could help me out here... I have a table with various fields which are varchar's and i need to convert them to a datetime format... This is the format : 2004:05:10:15:39:43.477 Hope someone can help...

Hi Could someone tell me if there is a function within Oracle that is similar to SQL Servers DATEDIFF...? I need to establish the difference in seconds between two dates in the following format : 2004:05:10:16:04:33.12 Thanks people....

$2=="CDR"{ if(length(buf))print buf buf=$0 } /AddressStringDigits/{buf=buf","substr($3,4,(length($3)-5))} /Imsi/{buf=buf","substr($3,4,length($3)-6)} /TypeOfNumber/{buf=buf","substr($3,4,length($3)-5)} /NumberingPlan/{buf=buf","substr($3,4,length($3)-5)}...

Worked it out, thanks for your help.

That certainly gets me the information, however, how would i get it to output only the values i.e. : -- CDR971,07958225180f,1 Thanks for your help...! -- CDR 971, ( AddressStringDigits 0x"07958225180f"), ( CallTypeLevel1 0x"01") -- 1,

No idea how i would go about this, completly new to awk, but does anyone know how i would do the following : I need to pull from a file all lines where the line has AddressStringDigits in it and CallTypeLevel1,2 &3... and enter into a new file For example : CDR 25,( AddressStringDigits...

No idea how i would go about this, completly new to awk, but does anyone know how i would do the following : I need to pull from a file all lines where the line has AddressStringDigits in it and CallTypeLevel1,2 &3... and enter into a new file For example : CDR 25,( AddressStringDigits...

I'm sure this is a really basic question, but is it possible to select a whole diagram and reduce the size of it on the page...? Thanks in advance

Try : SELECT field1, field2, field3 FROM table1 WHERE field1+field2+field3 IN( SELECT field1+field2+field3,count(1) FROM table1 HAVING count(1) > 1 GROUP by field1, field2, field3) Ta

Ok i will give it a go .. Ta

I managed to get the result i wanted using : (CONVERT(MONEY, (AllNat.TotalDownloads - TMI.TotalDownloads)/(CAST(TMI.TotalDownloads AS FLOAT)))*100) Thanks all the same nick

Is it possible to show a Int value as a decimal..? I am trying to work out a variance based on a total difference/total*100, my datatypes are integers and the result returned is 0. Is this possible...? Here is my query and results... Thanks for any ideas. SELECT TMI.[Date]...

ALTER TABLE tableA ADD (cod_channel Varhcar(??)); INSERT INTO tableA (A.id,A.cod_a,A.cod_b,A.cod_c,A.notes,B.cod_channel) SELECT id,cod_a,cod_b,cod_c,notes,cod_channel FROM tableA A,tableB B WHERE A.id = B.id;

They are an alias....

Use NVL(max(ainv2.po_number),'NULL') This will return a Null in that field if it does not exist......