conversion into date datatype [message #168776] |
Sat, 22 April 2006 09:35 |
vk_appstech
Messages: 22 Registered: October 2005 Location: hyd
|
Junior Member |
|
|
Hi All,
can some one give me the best way to convert a varchar into date.
lets say for example i have a column(varchar2) that contains 22apr2006.now i have to convert this string format into date format for the column that contains Date datatype.
hope i am clear.
Thanks in Advance
vk
|
|
|
|
|
Re: conversion into date datatype [message #168872 is a reply to message #168776] |
Sun, 23 April 2006 23:15 |
vk_appstech
Messages: 22 Registered: October 2005 Location: hyd
|
Junior Member |
|
|
srini
i have 40 columns of data type VARCHAR2.so i dont want to use the to_date for every column.so i was actually trying for some generic functionality to convert all at once during conversion process(from legacy system).Hope you got my point now.
|
|
|
|
|