Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Convert Varchar2 to Date Format
I am trying to convert a varchar2 field into a specific date. The values in the column have the format of 01/23/2008 and I would like it to be 2008-01-23. I have tried select to_date('column_name', 'YYYY-MM-DD') but I get an error returned from Oracle that it is an invalid month. Appreciate...- perlcamp
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
Sub Help - dealing with hyphens
I have a file of records that look like this: 123-456,RTY,76-78,12-09-87,key I would like to remove the hyphens from the first, and fourth values as delimited by commas but not the third value. So I would like to have the record look like this: 123456,RTY,76-78,120987,key Can I do this... -
RegExp using variables like \1 \2 and concat that value with a number
I have records in a file that look like this: IPOD,YAHOO,0033092909,50/4Z1,technology_102 I would like to convert the 4Z1 to 42001 so the complete record would look like this: IPOD,YAHOO,0033092909,50/42001,technology_ So essentially what I am trying to do is find records that have a slash /...
