date format [message #422740] |
Fri, 18 September 2009 10:20  |
miroconnect@yahoo.com
Messages: 202 Registered: April 2006
|
Senior Member |
|
|
I was looking data in my table I found this date '10/1/2001'
looking at this I don,t know which is month and which is date , how can I identify that ?
|
|
|
|
|
Re: date format [message #422752 is a reply to message #422740] |
Fri, 18 September 2009 12:17   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
That's easy, you just look at your NLS_DATE_FORMAT, because you are storing DATEs in a DATE column and not a VARCHAR2 of course.
Or the lazy was is just to select sysdate from dual and see the format, because
|
|
|
Re: date format [message #422818 is a reply to message #422740] |
Sat, 19 September 2009 17:20  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
My assumption is you are looking at a string column (varchar2/char). All the above are good ideas and may prove helpful in answering your question, but in the end you should be following this process:
1) go to your DBA and ask for the definition of the column. It is their job to tell you which is the month and which is the day.
2) then if the column is a column meant to store dates, ask who modeled it.
3) ask the person/people identified in #2 if indeed they defined a date field as a character string.
4) if they say yes, fire them and get someone who knows better.
Good luck, Kevin
[Updated on: Sat, 19 September 2009 17:22] Report message to a moderator
|
|
|