|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 12th, 2005, 01:35 AM
|
|||
|
|||
|
ORacle time formatting help
i have 2 create a databse for an assignmetn i haev created it inserted all the data, then when i was chekign the data one of the fields ios totally wrong, the time field which i thought i had set up correctly is not workng here is cone of the insert statements and its result
INSERT INTO ClientOrder (Order#, DateOfDelivery, TimeOfDelivery, ClientID) VALUES ('001','01-JUN-2005',TO_Date('12:00', 'HH24:MI'),'0000000004'); i want it to display the time here ^^^^^^^ but its displays it like this ORDER# DATEOFDEL TIMEOFDEL CLIENTID ------ --- - -------- ---------- 1 01-JUN-05 01-MAY-05 4 the time field is displayed as a month not as 12:00 as i would like it 2, if anyone knows how i can fix it let me know please, and to fix it i just update the fields yeh?? Nerd Newbie
|
|
#2
May 12th, 2005, 03:20 AM
|
||||
|
||||
|
Why don't you try to:
1. Check your spelling ( Quote:
2. Check what you are doing (you posted in the MySQL forum an Oracle specific question) After this you might be able to achieve some results ...
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > ORacle time formatting help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
