Oracle 10g Database Standard (ODBSEONUPP0) Logo

Related Topics:

Anonymous Posted on Sep 09, 2008

Oracle date functions problem

When I use Oracle date functions Format, the date format is - DD-MM-YYYY, on other machines, when I use the same function, I get this date format MM-DD-YY, this is really confusing how can I change it so both machines use the same date format?

1 Answer

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1helpful
1answer

I want to know when on my mobile phone it asks my date of birth and when entered says it wrong i think i should know when i was born

It seems like you are not entering it in th right format like:
DD/MM/YYYY which mean two digits for the two for the month and for the year 01/01/2015 now this is just one example there many different formats like yyyy/mm/dd mm/dd/yyyy mm.dd.yyyyy and so on
Mar 11, 2015 • Cell Phones
3helpful
2answers

My Nokia E5 is set by default to daylight saving mode, but it is canceled this year in Egypt, so I need to uncheck the auto adjust daylight saving but I cannot.

1 Press Menu or and select Settings.
2 Select Date & Time and choose from the
list below:
Set date - You can enter the current date.
Date format - You can set the date format.
(YYYY/MM/DD, DD/MM/YYYY, MM/DD/YYYY)
Set time - You can enter the current time.
Time format - You can set the time format to
either 24 hours or 12 hours.
Auto update - Select OFF, the phone will NOT
automatically update the date and time.
0helpful
1answer

I'm not understanding how to change the date in the date worksheet on the BAII. When I enter the numbers and (enter), I get and error 6. Any suggestions on what I'm doing wrong?

Error 6 indicated an invalid date, such as a month greater than 12 or a day greater than 31.

The calculator has two different formats for dates: DD-MM-YYYY and MM-DD-YYYY. To see the current format, press 2nd [FORMAT] down-arrow down-arrow. To change the format, press 2nd [SET]. Press 2nd [QUIT] to exit.
5helpful
2answers

My LG KS360 phone has developed a date fault since 1 Jan 2011 whereby it is saying 32/83/2010. I cannot fix it. Please advise.

Noticed the same problem today. The "set date" option wouldn't let me reset the day, month or year to anything sensible. Changed the date format to MM/DD/YYYY (it was previously DD/MM/YYYY). Then it let me set correct month, day and year. Reset the date format back to DD/MM/YYYY and it's still correct (and will now let me change it while in this format). Don't understand it, but seems to have fixed the problem. (Guessing it was something to do with 2009 changing to 2010??). worked for 2011 also.
Jan 02, 2011 • Cell Phones
0helpful
1answer

I was tryin to do some some simple interest on my calculator and when I was computing the days between daates using the 2nd and 1 function ... I put in the first date pressed enter and "error 6"...

You've input an invalid date, for example the month greater than 12 or the day greater than 31. The BA-IIPlus can handle dates in two different formats, the US MM-DD-YYYY and the European DD-MM-YYYY formats. Make sure you enter the date in the proper one. You can see current the format by pressing 2nd [FORMAT] down-arrow down-arrow and change it by pressing 2nd [SET]. Press 2nd [QUIT] when done.
8helpful
1answer

Canon P170-DH Calculator

CLOCK & CALENDAR FUNCTION

Look for the key with the cal/clock pic on it. Use to switch between calendar or clock mode. It is next to the feed key.
(12/24) Key used to switch between 12 or 24 hour at clock mode.
(Time Set) Key used to set the date and time in calendar & clock mode.
(AM/PM) Key used to switch between AM or PM at clock mode time setting.
(Format) Key used to select date format between "YYYY/MM/DD",
"DD/MM/YYYY" or "MM/DD/YYYY" at calendar mode.
Hope this helps, play with it I figured it out with instruction sheet.

0helpful
1answer

How do you set the date on an LG KS360

http://www.o2.co.uk/deviceinfo/device-pdfs/lgks360eng.pdf

Manual
Hope it helps.

Most cell phones get the info from the provider based on your triangulation.

It is in the Settings Menu.
Under DATE & TIME

More detailed Instructions....
Changing your date & time
You can set functions relating to the date
and time.
1 Press Menu or and select Settings.
2 Select Date & Time and choose from the
list below:
Set date - You can enter the current date.
Date format - You can set the date format.
(YYYY/MM/DD, DD/MM/YYYY, MM/DD/YYYY)
Set time - You can enter the current time.
Time format - You can set the time format to
either 24 hours or 12 hours.
Auto update - Select On, the phone will
automatically update the date and time.
Jan 03, 2009 • Cell Phones
1helpful
1answer

Xerox workcentre Pro 575 How do I change the time of day setting

  1. From the Standby Mode, press the [Menu] (up arrow) button, then press [4], [2]. The screen will display: Date.
    [01-31-2000]
  2. Use the numeric keypad to enter the date and the arrow buttons to move between the fields, then press [Enter]. The screen will display:Date format.
    1. MM-DD-YYYY
    2. DD-MM-YYYY
    3. YYYY-MM-DD
  3. Use the numeric keypad to designate the Date format you require to use. The screen will display: Month format.
    1. Numeric: displays the month with a number
    2. Name: displays an abbreviated month name.
  4. Use the numeric keypad to designate the Month format you require to use. The screen will display: Time format?
    1. 24 hour
    2. 12 hour
  5. Use the numeric keypad to designate the time format you require to use. The screen will display: Time.
    10:30 pm (or 22:30 pm if you chose the 24 hour format).
  6. Use the numeric keypad to enter the time and the arrow buttons to select [AM] or [PM], then press [Enter].
  7. Press [Exit] or [Stop] when the menu selection screen displays to return to the Standby Mode.
0helpful
1answer

Date format in quickbooks 7.4

If it's anything like Excel, someplace in the FORMAT menu should be options to allow you to change the date format. (Block off the cells, row, or column in question, click FORMAT in your toolbar.) You may have different country options or formatting choices within the date type.
5helpful
1answer

Setting date/time

Press the calendar/clock button
Hold the M+= button until the first digit of the date/time begins to blink
Set the time using this format- hh:mm
Set the date using this format- dd:mm:yyyy,
July 15, 08=15:07:2008 (I got this step wrong thinking the format was mm:dd:yyyy)
Press the M+= button again.
Not finding what you are looking for?

285 views

Ask a Question

Usually answered in minutes!

Top Oracle Computers & Internet Experts

ADMIN Andrew
ADMIN Andrew

Level 3 Expert

66963 Answers

Bonded Repair

Level 3 Expert

407 Answers

ADMIN Eric
ADMIN Eric

Level 3 Expert

39390 Answers

Are you an Oracle Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...