How do I Convert from DD-MM-YYYY hh24:mi:ss to YYYY-MM-DD hh24 Using oConv(iConv ???? Please advise
![Smile :-)](./images/smilies/icon_smile.gif)
Michael Mills
Moderators: chulett, rschirm, roy
Code: Select all
Oconv(Iconv(Field(InLink.TheTimestamp," ",1,1),"DDMY"),"D-YMD[4,2,2]") : " " : Left(Field(InLink.TheTimestamp," ",2,1),2) : ":00:00"
I think a better option is to use sub-string and rearrange the date.moose2079 wrote:I have a source Varchar(38) field in a sequential file that I want to load to an Oracle DataBase target column (using a Bulk Loader) - the target field is a TimeStamp
How do I Convert from DD-MM-YYYY hh24:mi:ss to YYYY-MM-DD hh24 Using oConv(iConv ???? Please advise
Michael Mills