exhaustive, The aims of the said examples are with a minimal knowledge or recap of your oracle sql strength, we should be able to generate application software,
Apart from selective data type retrieval, there are certain functions are used for conversion of data types
14.01 How to convert date type value to char type value
1, To-char( ) Transforms a date or number into a character string, For example, sysdate generally displays date as dd-mon-yy (18-Jun-10), In case, if we want to see the date in did-mm-ivy format, we shall use the "select to_char(sysdate,'dd-mm- yyyy') as formatted_date from dual" and result
will be
Formatted-Date
- - - - - - - - - - - -
18-06-2010
Describe what you're looking for in as much detail as you'd like.
Our AI reads your request and finds the best matching books for you.
Popular searches:
Join 2 million readers and get unlimited free ebooks