•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,440 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,838 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 1024 | Replies: 2
 |
•
•
Join Date: Oct 2006
Posts: 34
Reputation: 
Rep Power: 2
Solved Threads: 1
Light Poster
Hi,
I have a question. Please help me out.
What is the default "display date format" and default internal "accepting date format"? How to change the default display and accepting format. In my system, the default display date format in sql * plus is dd-mon-yy, where as in toad it is mm/dd/yyy HH:MI
S AM
Can we change these two default display date format.I know I can use to_char. But without any explicit conversion functions during the selection.
insert into mine_date values(to_date('22/03/1984','dd/mm/yyyy'))
What is the internal date format of the date(22/03/1984)that has been changed by to_date function.
I have a question. Please help me out.
What is the default "display date format" and default internal "accepting date format"? How to change the default display and accepting format. In my system, the default display date format in sql * plus is dd-mon-yy, where as in toad it is mm/dd/yyy HH:MI
S AMCan we change these two default display date format.I know I can use to_char. But without any explicit conversion functions during the selection.
insert into mine_date values(to_date('22/03/1984','dd/mm/yyyy'))
What is the internal date format of the date(22/03/1984)that has been changed by to_date function.
•
•
Join Date: Nov 2004
Location: Netherlands
Posts: 5,752
Reputation:
Rep Power: 18
Solved Threads: 197
Oracle stores dates as numbers, the display format is ALWAYS determined by the client, not the server.
As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.
|
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
access advice broadband business classification code combo crime cult of the dead cow daniweb data data protection data transfer database drive dropdownlist encryption europe forensic forensics gadget google government hacking hard hardware help hitachi hp industrial espionage information internet linux mobile module net news payment services privacy protection reuse search security spot storage terabyte tutorials and more tv web wikipedia
- Data type initialization error (C++)
- Date and Time (ASP.NET)
- Posting News according to today's date (ColdFusion)
- problem with date query (ASP)
- Sorting in date order (Visual Basic 4 / 5 / 6)
- Date Alert Reminder (C)
- help on data type conversion (Visual Basic 4 / 5 / 6)
- Multiple data being read in (C++)
Other Threads in the Oracle Forum
- Previous Thread: Database Creation problem in Oracle
- Next Thread: Table drop and Dependent Objects
