Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.
Total Post History
7-Day Post History
- New Posts:
- New Topics:
- Active Topics:
Our newest member
All times are UTC [ DST ]
As per my catchy title, I am having a ball ache with Oracle 11g. It's all new to me but learning fast, have come across one annoying problem at the moment chaps and that is to do with dates.
The NLS_DATE_FORMAT is set to DD-MMM-YY on our databases, a result of dealing with a Y2K bug some time back (yes that old chestnut).
Now I have a .NET application that passes a nullable datetime value to a PROC which in turn has a simple insert procedure that writes a date of birth value to the database eg:
However when the date is written to the database it is stored as:
This is driving me nuts and most probably due to my lack of experience with all things Oracle I am missing something obvious. I have tried using:
However not had much luck, the date either gets stored as:
Does anyone have any suggestions how to resolve this (short of altering the date format which is not ideal).
Thanks in advance,
- LTD Admin
- Posts: 571
- Joined: Thu Oct 11, 2007 11:14 am
- Location: United Kingdom