Hi
when i start my Apache, i get a series of error messages in the error_log file:
[Wed Jul 17 11:33:00 2002] [notice] jrApache[init] mod_jrun: JRun Connector v2.3.149 static Apache - Aug 12 2001 23:28:43
[Wed Jul 17 11:33:01 2002] [notice] jrApache[init] mod_jrun: JRun Connector v2.3.149...
Hi
i have a series of user parameters that i would like to 'build' a date from for a comparison against a date field in a table.
the parameters are &dd, &mon, &yyyy, &hh24 and &mi.
how can i put them together in the format &dd:&mon:&yyyy:&hh24:&mi:00 in order to use them in a date comparison...
Hi
I wish to select the distinct year from a series of rows in a table. the date column is in the format dd:mon:yyyy:hh24:mi:ss, how do i retrieve the distinct year part from these rows?
Thanks in advance
Stephen
Hi
using Oracle 8.1.7.2
I wish to create a series of views that contain date portions in order to populate drop down boxes.
I wish to create seperate views of:
Days
Months
Years
Hours
Minutes
I have a table that is loaded with data every night, this table contains date entries in the format...
Hi
i am using oracle 8.1.7.2 and need to have an alternative within a select statement.
I am calculating the percentage failure from some data
(failure/attempts) * 100
there is the potential for the attempts to = 0, so this will potentially produce an error in the select statement.
how do i...
I have managed to find a compound statement to perform what i am looking for:
select SUBSTR( CUSTOMER_SITES.NAME, 0, ((INSTR(CUSTOMER_SITES.NAME, '-', 1,1)) -1))
Is there a simpler way of performing this select??
Hi
I wish to select from a column, the names of customers. These names are in the format: "customername-location".
how can i ignore everything after the "-" character and just select the customername section?
i have looked at the substr() function, but as the customername...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.