This Blog will help you to understand how Date are stored in Oracle database and how it can be retrived as a character in any format. First of all, the basics. Open SQL*Plus and give the following SQL statement. select sysdate from dual; This statement will return depending upon the date settings. In my system it returned sysdate -------- 14-Jul-2005 This is what Oracle knows what a date is. That is speaking more clearly, without a format date have the 'dd-mon-yyyy' format in Oracle. Oracle always stores date values in the above format if the session date format is not changed. To select some other formats, you must specify select to_char(sysdate,'dd/mm/yyyy') from dual; to_char(sys ------------ 14/07/2005 The above select statement has a major difference with the first one. In the first one Oracle returned date datatype whereas in second we converted it to character and Oracle returned as per my requirement. But what if I am displaying it in this format but I want to s...
