Home » SQL & PL/SQL » SQL & PL/SQL » date format (oracle 10)
date format [message #422740] Fri, 18 September 2009 10:20 Go to next message
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 #422743 is a reply to message #422740] Fri, 18 September 2009 10:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>looking at this I don,t know which is month and which is date , how can I identify that

Look at other dates to see which part has value greater than 12
Re: date format [message #422744 is a reply to message #422740] Fri, 18 September 2009 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is the type of your field?

Regards
Michel
Re: date format [message #422752 is a reply to message #422740] Fri, 18 September 2009 12:17 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: Excel report not formatting correctly in SQL*Plus (multi-merge)
Next Topic: convert oracle to ms server 2005
Goto Forum:
  


Current Time: Sun Feb 09 08:03:41 CST 2025