Recent content by nread

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