In DB2 there is a function named timestamp_iso()
Like if I make a SQL
select current time, timestamp_iso(current time) from dual
The output will be
9:13:31 PM 4/11/2008 9:13:31 PM
1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]
which means for column one is '9:13:31 PM'
for culumn two is '4/11/2008 9:13:31 PM'
My question is, do we have corresponding function in Oracle for 'timestamp_iso'?
Message was edited by:
there is no built-in function in Oracle with the same result, but you can easily make your own one by using to_char() function.
Usage examples are here:
how to do that, if you don't know format of the incoming parameter of this function. You don't know is it '21:00:01' or is it '21-May-2010' or is it '11-01-09'? How in this case you propose to use to_char()?