LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

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.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Highly Rated Users

Forum
No Posts Rated

Top 50
Given
Received

Links

Wiki
Blog

Forum Statistics

Users
Members:
1881
Members Online:
3
Guests Online:
55

Total Post History
Posts:
81455
Topics:
18718

7-Day Post History
New Posts:
1
New Topics:
1
Active Topics:
1

Our newest member
jusnailtop

Other

FAQ
All times are UTC [ DST ]

Oracle "blind date" from hell

Please wait...

Oracle "blind date" from hell

Postby Kermit on Sat Jul 20, 2013 1:15 pm

Hi,

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:

  1. 17/03/1940    (no that's not my birthday...)
  2.  
  3.  


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:

  1. to_date(myinputdateval, 'DD-MM-YYYY')


or

  1. to_date(myinputdateval, 'DD-MM-YY')


However not had much luck, the date either gets stored as:



Or as:



Does anyone have any suggestions how to resolve this (short of altering the date format which is not ideal).

Thanks in advance,

Kermit
MotherFbleeper
User avatar
Kermit
LTD Admin
LTD Admin
LTD Bronze - Rating: 125LTD Bronze - Rating: 125LTD Bronze - Rating: 125
 
Posts: 571
Joined: Thu Oct 11, 2007 11:14 am
Location: United Kingdom
Unrated