nikos
Last Activity: Mar 19 '08, 08:51 PM
Joined: Mar 12 '08
Location:
-
yeah, i basically need to select the year of 2003 and insert it into DATE configured column as 2003 without month or day. Another possibility would be to insert it as a string, but i would need to convert those two entries only (ie, YYYY and MM/YYYY)... -
The original table is from excel, so in excel there were those dates (year, and month and year) to indicate a start of event....Leave a comment:
-
converting Date to Date or Char
Hi,
I have a table with one of the columns configured to record dates as ('#', 'MM/DD/YYYY'). However, two entries in that column are of format YYYY and MM/YYYY. How can I change only those two entries preferably to Date but in formats above?
i tried to do:
[code=oracle]
"update table_name
set column_name = to_date('2008', 'YYYY')
where c_id = 12"
[/code]
but it records the... -
comparing string values
Hi,
I am very new to oracle and have some problem figuring out how to compare two string columns in different tables for non-similarity.
suppose i have column a in table 1 as t1.column_a and column b in table 2 as t2.column_b.
i want to see unique entries that are not equal to each other....if t1.column_a has some entries that are not present in t2.column_b and if t2.column_b has some entries not present in t1.column_a....
No activity results to display
Leave a comment: