I have a table with a DATE field which i want insert the current date into, is there a way to insert the current date with the following format : dd-mm-yyy as and example 03-08-2007 using sysdate ?
Thanks in advance ...
Oracle uses a specific format for internal storage (RR date format). When a DATE is instantiated, it represents a day(say Jan 1 2004) ... the formats are applicable only when we want to represent this date in different ways. The way it is stored in the database is always the same.
Eg -While selecting data , we can use to_char function to get it in the dd-mm-yyyy format as shown below
Hope this helps
We don't have time to be charming! Quick, read this tiny ad: